Hello!
These seems deceptively simple but I can't find any example online that answer this (or am searching for the wrong thing)
Any help would be great.
Considering this table:
<tbody>
</tbody>
How do I ask, "how many customers bought both apples and pears?" (which would be 1, Anne)
( If I say, Calculate(Distinctcount('table'[Customer]),table[Fruit]="Apple" || table[Fruit]="Pear])) then I get 3...which is wrong )
Kindest regards,
Alex
These seems deceptively simple but I can't find any example online that answer this (or am searching for the wrong thing)
Any help would be great.
Considering this table:
Customer | Fruit |
Anne | Apple |
Anne | Pear |
Bob | Apple |
Cindy | Pear |
<tbody>
</tbody>
How do I ask, "how many customers bought both apples and pears?" (which would be 1, Anne)
( If I say, Calculate(Distinctcount('table'[Customer]),table[Fruit]="Apple" || table[Fruit]="Pear])) then I get 3...which is wrong )
Kindest regards,
Alex