Only display values that include ALL slicer selections - not Either/Or

[Turnipface]

Hey PowerBI Community,

I have a challenge that's addressed in another thread, but it does not entirely work for me.

I have this .pbix file that i've made to simulate my environment: https://we.tl/t-scjeXQwrVz 
On one table, I have the Orders (location doesn't matter)

Order ID	Location
1	Earth
2	Mars
3	Moon
4	Earth
5	Earth

On another table, i have the Products. Both tables are linked by Order ID

Order ID	Product
1	Chair
1	Cucumber
2	Chair
2	Cucumber
3	Chair
4	Chair
5	Chair
5	Cucumber

What i need to find out is:  Orders that have both Chairs and Cucumbers. 
How would i go about creating a slicer that will filter based on ALL selected values in it? In the above case, that'd mean that it'll result in 3 total orders - 1, 2 and 5 because they're the only ones that have both items.

If i do that via a standard slicer by Product, i will get orders that have either a Chair or a Cucumber. (see picture below)

Any help with this will be highly appreciated! 

[Greg_Deckler · Accepted solution]

This was the purpose of my Patient Cohort Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883

[LukeMcManagan]

Hi Greg, thanks for creating this!

I'm trying to take it to the next level and filter the "Patients" table based on the concatenated list of patients that match the selection in the filter. Any ideas on how I might do that?

[Turnipface]

That's precisely what i was looking for! The Count of Cohorts in particular will really help me out.

Thanks for your solution!

[Greg_Deckler]

Cool, glad I added that variation then!