Binary measure of the max of several variable

[Jeremy19]

Hi,

I need to create a measure equal to 1 if it is the maximum Pct and after the maximum of Nb, and 0 otherwise to be able to then filter my visuals on this measure. 

My data :

Zone1    Zone2     Pct      Nb    ExpectedResult

A              A           0.2      10          1

A              B           0.2       10         1

A              C           0.2       10         1

B              A           0.1        5          0

B              C           0.1        5          0

C              B           0.2        7          0

I think it must be an IF condition with the MAX function inside but I can not do it. Can you help me?

[v-xuding-msft · Accepted solution]

Hi @Jeremy19 ,

I created a calculated column to implement it you can have a try.

result = 
var a = MAX('Table 1'[Pct])
var b = MAX('Table 1'[Nb])
return
IF('Table 1'[Pct] = a &&'Table 1'[Nb] = b ,1,0)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.