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

Elcin_7's avatar
Elcin_7
Icon for Helper I rankHelper I
2 years ago

I think to achive what you want you need to use Matrix visual. Raw will be athlet and value will be velocity.

 

RANKX(ALLSELECTED(table(athlet name), Tablename(Max velocity),Tablename(Max velocity),DECS,Dense))