Highlighting Changes in a Matrix and hiding rows with no change

[FU]

Hi all,

I have a matrix shown below and I am trying to create a measure or filter which compares each column and if there are no changes in my date columns then show blank for that specific row. 

I ONLY want to be able to see rows that have different values across each date column. 

EXAMPLE: the last row shows 'Brownish' for Dec-22 and 'Red' for the rest of the columns. I would want to keep this row visible as it has changes. The rest of the rows are identicial therefore can be blank.

Can someone explain how this could be done?

Happy to attach the data set if needed. Thank you. (the blue shape is blocking sensitive data)

[FU]

@olgad 
That didn't quite work for me.

So using my table above I have only 1 row that has changes. It does't seem to be showing that. It's counting all the distinct rows (9 rows)

[olgad]

Check if you are using a distinct count as a filter from the new table "summary", if you are summarizing there the correct column (the one with values)

[FU]

Hope thats clear - I am using the DistinctCount from the table 'changes'

[olgad]

One cannot see the what you are defining as distinct count

let me send you my file may be you see the difference, because if step one worked then step 2 is based on that measure which i named as "distinct count" in first step and reused in summary table. 

[FU]

send your file over and ill take a look 🙂

[olgad]

pbix 

[FU]

I saw your file and did the same but still did not work. 

Note: I have 9 unique rows as you can see in my first screenshot. But after I show only changes rows I have 1. 

I cannot see 1 in the card I see 9

[olgad]

Changes = SUMMARIZE('Project Risks Query-xxx','Project Risks Query-xxx'[Risk ID],'Project Risks Query-xxx'[Attribute],"DistinctCount", [DistinctCount])

and delete the relationship if it gets created/adjust many to many.
Risk ID had to be included into the formula.

[FU]

What happens when there is more than 1 row under the same Risk ID?

[olgad]

Ok, then we have differences in data structure.  It doesnt matter you have 9 i have 5. in the end i see 3 not 5. so, check whats different on your side in data structure. Or if you can send me your file then i can solve it. 

[FU]

Okay I have sent you my file in a private message

[FU]

the final word is [DistinctCount]) as per your table below. 

Okay send over your file

[olgad]

Can you attach a snapshot? Where i can see the calculation you are doing and the result?

[FU]

@olgad 
Thank you for the solution - that seemed to work!

How would I be able to create a Card to count the number of rows that contain changes?

[olgad · Accepted solution]

create a table:

Changes = SUMMARIZE(Table1, Table1[Category],"DistinctCount", [DistinctCount])

Then take the count of category and once again the distinct count is greater than one

I will appreciate if you give a like to my answers and mark the solution as accepted if that works for you and answers your question.

[olgad]

Hi there,

supposedly you have such data structure:

Create a measure:

DistinctCount = DISTINCTCOUNT(Table1[Value])

Place that measure onto the Visualisation Filter and set it to greater than 1 and there you have it. 

Hope that helps.