Forum Discussion
Advocate IOnly display values that include ALL slicer selections - not Either/Or
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!
This was the purpose of my Patient Cohort Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883
4 Replies
- Greg_Deckler
Community Champion
This was the purpose of my Patient Cohort Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883
TurnipfaceThat'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!
LukeMcManaganAdvocate II
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?