Forum Discussion
Solved
Highlight non-duplicate if data from two columns
Hello, I have monthly reports of account memberships in security groups and I am trying to figure out how highlight non-duplicate data. Month Account Name Security Group Nov bob a...
Hi Celborn ,try this:
- Create a calculate column:
Concat_ = 'Table'[Account Name]&'Table'[Security Group]- Create this measure:
Color = if(CALCULATE(count('Table'[Concat_]), ALLEXCEPT('Table','Table'[Concat_]))=1,"red","black")- Put the measure in conditional formatting for your table:
- The result:
Best regards
Hi Celborn ,try this:
- Create a calculate column:
Concat_ = 'Table'[Account Name]&'Table'[Security Group]
- Create this measure:
Color = if(CALCULATE(count('Table'[Concat_]),
ALLEXCEPT('Table','Table'[Concat_]))=1,"red","black")- Put the measure in conditional formatting for your table:
- The result:
Best regards