Forum Discussion
Need help with ranking function
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 I just want it to rank each persons best so it would be 1 to 32 instead of having thousands of values.
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Player 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 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
