topic Re: Need help with ranking function in DAX Commands and Tips

Need help with ranking function

mmadiganjr — Thu, 16 May 2024 18:25:24 GMT

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.

Re: Need help with ranking function

lbendlin — Fri, 17 May 2024 00:48:25 GMT

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/1447523

Re: Need help with ranking function

mmadiganjr — Fri, 17 May 2024 11:51:25 GMT

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

Re: Need help with ranking function

mmadiganjr — Fri, 17 May 2024 11:51:44 GMT

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

Re: Need help with ranking function

lbendlin — Fri, 17 May 2024 12:39:16 GMT