Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Max Rank

Hi I have the following table MeterNo Value Rank Max Rank 123 10 1 123 20 2 123 30 3 MAX 456 10 1 456 20 2 456 30 3 MAX Tabl...

7 years ago

Hi Anonymous

Try this for your calculated column:

MaxRank =
IF (
    Table1[Rank] = CALCULATE ( MAX ( Table1[Rank] ), ALLEXCEPT ( Table1, Table1[MeterNo] ) ),
    "MAX"
)

Community Champion

7 years ago

Hi Anonymous

Try this for your calculated column:

MaxRank =
IF (
    Table1[Rank] = CALCULATE ( MAX ( Table1[Rank] ), ALLEXCEPT ( Table1, Table1[MeterNo] ) ),
    "MAX"
)