Forum Discussion
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 | admin |
| Dec | bob | admin |
| Nov | jake | exchange admin |
| Dec | jake | exchange admin |
| Dec | billy | exchange admin |
I am trying to get it to highlight the last row since it is the unique data
I was trying (without luck)
unique = COUNTROWS(
FILTER(ALL(Data),
Data["account Name"],Data["Security Group"] =! EARLIER(Data["account Name],Data["Security Group"])
)
)
any help would be appreciated
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
4 Replies
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
Try:
Highlight non duplicate = IF ( CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Account Name], 'Table'[Security Group] ) ) = 1, "Light Green" )Sample PBIX file attached
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.
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.
