Forum Discussion

mmadiganjr's avatar
mmadiganjr
Frequent Visitor
2 years ago
Solved

need help with ranking

Hello, trying to rank each persons "Player Name" highest value of "Maximum Velocity".  I've been successful showing a rank but it's including every single max velocity value and not just their best, ...
  • HotChilli's avatar
    HotChilli
    2 years ago

    Create 2 measures:

    M1 = MAX(TableT[Maximum Velocity])

M2 = RANKX( ALL( TableT[Player Name]) ,  [M1])

    Put them in a table with Player Name

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Create 2 measures:

M1 = MAX(TableT[Maximum Velocity])

M2 = RANKX( ALL( TableT[Player Name]) ,  [M1])

Put them in a table with Player Name