Let’s have a look at this table:
In the explore we have:
Measure: Number Of Customers (count distinct customer ID)
Measure: Number Of Orders (count disitinct order ID)
The question I want to find an answer is:
How many customers ordered both Guitar and Ocarina across all orders? Answer is 1 (customer A)
What would be the best way to model it? I understand that in this explore it is not possible to do that, or am I wrong?