powerbi - Can we compare a row value with another row value in the table and highlight it in Power BI?

Question

I have a table where 3 columns can have same value

Example:

Name Score_a Score_b Score_c
A    12       15     18
B    3        3       3
C    20      25       30

I want to highlight ( with a colour ) the row B since all the three scores are same.

I am unable to do it with conditional formatting available. Can something be worked out using DAX? Please help!

question from:https://stackoverflow.com/questions/65886515/can-we-compare-a-row-value-with-another-row-value-in-the-table-and-highlight-it

Answer 1

Yes, first create a measure using the following dax formula:

Measure = 
IF( 
    SELECTEDVALUE( 'Table'[Score_a] ) = SELECTEDVALUE( 'Table'[Score_b] ) && 
    SELECTEDVALUE( 'Table'[Score_b] ) = SELECTEDVALUE( 'Table'[Score_c] ), 1, 0
)

Then you need to use conditional format on every column that you want to highlight and select the Measure you created.

This is the result