cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 Name Activity Name Date Maximum Velocity Ath 1 WLAX Practice 11-3-23 11/3/2023 14.04 Ath 2 WLAX Practice 11-3-23 11/3/2023 13.69 Ath 3 WLAX Practice 11-3-23 11/3/2023 13.37 Ath 4 WLAX Practice 11-3-23 11/3/2023 17.05 Ath 5 WLAX Practice 11-3-23 11/3/2023 15.4 Ath 1 WLAX Practice 11-6-23 11/6/2023 12.79 Ath 1 WLAX Practice 11-6-23 11/6/2023 9.53 Ath 2 WLAX Practice 11-6-23 11/6/2023 14.53 Ath 2 WLAX Practice 11-6-23 11/6/2023 11.16 Ath 2 WLAX Practice 11-6-23 11/6/2023 10.91 Ath 3 WLAX Practice 11-6-23 11/6/2023 13.76 Ath 3 WLAX Practice 11-6-23 11/6/2023 9.97 Ath 4 WLAX Practice 11-6-23 11/6/2023 11.38 Ath 5 WLAX Practice 11-6-23 11/6/2023 10.49
1 ACCEPTED SOLUTION
Super User

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 2
Super User

Create 2 measures:

``````M1 = MAX(TableT[Maximum Velocity])

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

Put them in a table with Player Name

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors