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.
I am Trying to Flter some Rows in the Matrix Calcualtion , But unable to do the same.
This is how my matrix Looks Like, I want to filter the rows for Day 1 , Which has similar foods for Lunch/Breakfast and Dinner
BREAKFAST | LUNCH | DINNER | |
DAY 1 | Burger | Burger | Burger |
DAY 2 | Burger | Pizza | Pizza |
DAY 3 | Hot Dog | Hot Dog | Hot Dog |
Any help will be appreciated
Note: The Data set is in 1 Flat Table
Solved! Go to Solution.
hi, @richiearora2001
After my test, you may try this way as below:
Assume this is basic data
Step1:
Add a column to adjust whether it has similar foods for Lunch/Breakfast and Dinner each day
judge = IF(CALCULATE(DISTINCTCOUNT(Table1[Detail]),FILTER(Table1,Table1[Day]=EARLIER(Table1[Day])))>1,"different","similar")
Step2:
Darg this field into visual level filter or page level filter to filter is different.
Result:
or you could use another way:
Add a measure to adjust whether it has similar foods for Lunch/Breakfast and Dinner each day
Measure = IF( CALCULATE(DISTINCTCOUNT(Table1[Detail]),ALLEXCEPT(Table1,Table1[Day]))>1,"different","similar")
Then Darg this field into visual level filter to filter is different.
It has the same effect.
Best Regards,
Lin
Why not Day 3, which also has similar foods?
Thanks for Pointing out- Yes Even Third Row .
hi, @richiearora2001
After my test, you may try this way as below:
Assume this is basic data
Step1:
Add a column to adjust whether it has similar foods for Lunch/Breakfast and Dinner each day
judge = IF(CALCULATE(DISTINCTCOUNT(Table1[Detail]),FILTER(Table1,Table1[Day]=EARLIER(Table1[Day])))>1,"different","similar")
Step2:
Darg this field into visual level filter or page level filter to filter is different.
Result:
or you could use another way:
Add a measure to adjust whether it has similar foods for Lunch/Breakfast and Dinner each day
Measure = IF( CALCULATE(DISTINCTCOUNT(Table1[Detail]),ALLEXCEPT(Table1,Table1[Day]))>1,"different","similar")
Then Darg this field into visual level filter to filter is different.
It has the same effect.
Best Regards,
Lin
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |