Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional Formatting Duplicate Rows in Table that Adjusts with Filters

Hi, I have looked at ways of implementing Conditional Formatting of duplicate table entries, where a calculated column in used to count the number of duplicates for each row and then conditional form...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Anonymous 

 

Based on your previous description, if the name appears 10 times in the original data, but only once in the filtered table, the name should not be highlighted. What I understand is that you need to highlight the name many times in different conditions. I don't know if I understand it correctly.

 

You can try the following methods.

NameDistinctCount =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Condition] ),
    FILTER ( 'Table', [Name] = EARLIER ( 'Table'[Name] ) )
)

 

Highlight = 
IF ( MIN ( 'Table'[NameDistinctCount]) >= 2, "Red", BLANK () )

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I'm afraid this doesnt work - I can see in your first screenshot that the distinct count is not right - as it is giving a '1' value when there are duplicate names.

 

I don't know how else to describe it other than how I did on my previous message with the example screenshots.

Names need to be highlighted if it is a duplicate in the column. The highlighting needs to reflect what you can see with the filters applied - and not the original data.