Forum Discussion
Rank and Top N
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.
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:
TopN as viewed by DAX Table Queries
Regards,
Xiaoxin Sheng
3 Replies
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:
TopN as viewed by DAX Table Queries
Regards,
Xiaoxin Sheng
I was thinking in a solution without using a calculated column but you are right, that works!
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
