Count amount of observations with 2 different inputs in a specific column

[Sperling]

To simplify my data, here's an example - my data is different and something I can't share:

PersonID	Product
1	X
1	Y
2	X
3	X
3	Y
4	Y

What I'm interested in is getting count of how many people choose both X and Y - so above it would only count person ID 1 and 3.

I'm having trouble making the measure only count specific combinations of products.

[CNENFRNL]

Just for fun, a showcase of powerful Excel worksheet formulas,

 

[amitchandak · Accepted solution]

@Sperling , Try a measure like

countx(filter(summarize(Table, Table[PersonID]
, "_cnt", calculate(distinctCOUNT(Table[Product]), filter(Table, Table[Product] in {"X", "Y"})))
, [_cnt]=2),[PersonID])