how to get top/flop 5 with multiple columns

[benech]

Hi all

I have a table and I need to get TOP/FLOP 5 for a measure called 'perf' but for all columns not by group and I didn't find any answer yet. Hope someone can help!

I have three columns that need to be used, year, amount and score 

year      amount   score    perf  

2024       2K          12       8%

2023       1K          8         5%

2023       7K          5        -2%

2022       10K        3        -6%

2022       6K          1         2%

2024       15K         7         -1%

2024       5K          3         -7%

the expected result would be for the top5

year      amount   score    perf    rank 

2024       2K          12       8%      1

2023       1K          8         5%      2

2022       6K          1         2%      3

2024       15K         7        -1%     4

2023       7K          5        -2%      5 

Thanks a lot !! 🙂

[qqqqqwwwweeerrr · Accepted solution]

Hi @benech 

you can create rank columns by using this measure:

Rank = RANKX(ALL('YourTableName'), [ColumnToRank], , DESC, Dense)

and use that in filter 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards