Forum Discussion
Solved
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 ho...
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
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!
