Rank and Top N

[RHerrera73]

Hi,

I need your help. I have this table (source table) and I would like to:

- Rank the table based on number of complaints for 2018, and

- Then, grab the Top 5 and create a new table to show how these Top 5 reasons perform in previous years.

Thanks in advance.

[thisiskl]

Hi @RHerrera73 ,

It's been years but I'm having the same problelm. I understand the logic, but how did you achieve the second part using TOPN?

Thank you in advance

[Anonymous · Accepted solution]

HI @RHerrera73,

You can add calculate column to ranking based on 2018 column, the use TOPN function to create new table with top records base on rank column.

Reference:

How to use RANKX in DAX

TopN as viewed by DAX Table Queries

TOPN Function (DAX)

Regards,

Xiaoxin Sheng

[RHerrera73]

I was thinking in a solution without using a calculated column but you are right, that works!