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

lazurens2 — Wed, 21 Sep 2022 07:42:57 GMT

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

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

johnt75 — Wed, 21 Sep 2022 08:25:57 GMT

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

topic A DAX Measure to flag the max value (best score) in DAX Commands and Tips

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

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