Matrix Calculations

[richiearora2001]

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

[Greg_Deckler]

Why not Day 3, which also has similar foods?

[richiearora2001]

Thanks for Pointing out- Yes Even Third Row .

[v-lili6-msft · Accepted 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:

BeforeAfter

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