A DAX Measure to flag the max value (best score)

[lazurens2]

Hello, 

I am trying to create a measure that compares for every row in the table if Column2 = Max then 1 else 0. 

This is my try : 

Best Score = 
VAR _Max = Max('Table'[Column2])
Return 
    Maxx(FILTER('Table','Table'[Column2] = _Max),1)

I should 0 for a, b and e and 1 for c and d.

Any help is appreciated, thank you

[johnt75 · Accepted solution]

Best score =
VAR MaxValue =
    CALCULATE ( MAX ( 'Table'[Column2] ), REMOVEFILTERS ( 'Table' ) )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Column2] ) = MaxValue, 1, 0 )