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, and I just want it to rank each persons best against each other. The data set is very large so I provided an example below and would like the final ranking to look like this:

 

Ath 4 - 17.05 - Rank 1

Ath 5 - 15.4 - Rank 2

Ath 2 - 14.53 - Rank 3

Ath 1 - 14.04 - Rank 4

Ath 3 - 13.76 - Rank 5

 

Player NameActivity NameDateMaximum Velocity
Ath 1WLAX Practice 11-3-2311/3/202314.04
Ath 2WLAX Practice 11-3-2311/3/202313.69
Ath 3WLAX Practice 11-3-2311/3/202313.37
Ath 4WLAX Practice 11-3-2311/3/202317.05
Ath 5WLAX Practice 11-3-2311/3/202315.4
Ath 1WLAX Practice 11-6-2311/6/202312.79
Ath 1WLAX Practice 11-6-2311/6/20239.53
Ath 2WLAX Practice 11-6-2311/6/202314.53
Ath 2WLAX Practice 11-6-2311/6/202311.16
Ath 2WLAX Practice 11-6-2311/6/202310.91
Ath 3WLAX Practice 11-6-2311/6/202313.76
Ath 3WLAX Practice 11-6-2311/6/20239.97
Ath 4WLAX Practice 11-6-2311/6/202311.38
Ath 5WLAX Practice 11-6-2311/6/202310.49
  • 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

2 Replies

  • 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

  • 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))