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 

 

I simply simulated some data, hoping to solve your problem.

1. Create a new column to calculate the number of times the name appears.

Number of occurrences = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Use] ),
    FILTER ( 'Table', [Name] = EARLIER ( 'Table'[Name] ) )
)

 

2. Create a new measure to determine if a name appears multiple times to highlight it.

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

Turn on the background color option in the Conditional formatting section.

The settings are shown in the figure.

The highlighted results are shown in the figure.

Does this solve your problem? If it doesn't solve it what kind of results do you expect? Is it possible to provide a short version of the PBIX file for testing? Looking forward to your response, thank you!

 

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.