Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My table contains 20.000 names, where each name have several registrations based on which fruits they ate. So the table has 50.000-60.000 lines of data. I want to find out who did NOT eat a specific fruit? This is just a mockup to showcase the basic problem of my real table, which isn't about fruits 🙂
Is there a formula to retrieve the names of those who didn't eat an orange?
Name | Fruit |
John | Banana |
John | Orange |
Adam | Apple |
Adam | Banana |
Adam | Orange |
Lisa | Apple |
Chris | Banana |
Chris | Apple |
Solved! Go to Solution.
@AleksanderPunt
Create this measure and assign it to the visual filter and set it equal to zero.
Measure = INT(MAX(Table2[Name]) in CALCULATETABLE( VALUES(Table2[Name]) , Table2[Fruit] = "Orange"))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks, it looks like the solution from @Fowmy does the trick. Your approach @Anonymousis unfortunately out of my knowledge on how to achieve - I haven't used expressions editors, DAX Query's etc.. but thanks anyway! 🙂
I recommend you to create a Name table and a Fruit Table not to fall (ever) in auto-exist.
Here my approach (very similar to Fowmy's)
@AleksanderPunt
Create this measure and assign it to the visual filter and set it equal to zero.
Measure = INT(MAX(Table2[Name]) in CALCULATETABLE( VALUES(Table2[Name]) , Table2[Fruit] = "Orange"))
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |