Forum Discussion

Celborn's avatar
Celborn
Regular Visitor
3 years ago
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...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    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

     

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Try:

Highlight non duplicate =
IF (
    CALCULATE (
        COUNTROWS ( 'Table' ),
        ALLEXCEPT ( 'Table', 'Table'[Account Name], 'Table'[Security Group] )
    ) = 1,
    "Light Green"
)

Sample PBIX file attached