Forum Discussion
geeklarokcmie
Helper III
2 years agoHighlight unique/distinct rows in a visual
How can I tweak the below DAX measure to highlight distinct rows in a visual?
Rowcount : =
IF (
COUNTROWS (
CALCULATETABLE (
'Table',
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[Customer] )
)
) = 1,
0,
1
)
Was able to find solution from the below thread:
2 Replies
- AnonymousNot applicable
Hi geeklarokcmie ,
As I understand it, it's true if the Customer column is 1, so your true/false conditions could be "Red" and "yellow", and then use conditional format for the Customer column.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- geeklarokcmie
Helper III
Was able to find solution from the below thread: