Need help with Rank function dax

Hi Anonymous 

For questions where you want to find the batsman who scores the most points per year via the rank function, we recommend that you use “rankx”, as “rankx” sorts the same values in the column to the same level. This avoids over-sieving or missing data.

we have the following solutions:

Here's some dummy data

Create a measure, after grouping "Year", sort "Runs" in descending order

Top_Rank_Batsman = RANKX(FILTER(ALL('Table'),[Year]=MAX('Table'[Year])),CALCULATE(SUM('Table'[Runs])),,DESC,Dense)

Filter the data in "Filters" and select the record with a ranking of "1".

Here is the result

Best Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.