Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |