Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |