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

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

This calculated column formula should work

Is it unique? = calculate(countrows(Data),filter(Data,Data[Account Name]=earlier(Data[Account name])&&Data[Security Group]=earlier(Data[Security Group])))

Hope this helps.