Forum Discussion
How to do Ranking
I have a lot of compliance data that I am graphing by the delta. I have 55 different people I am trying to rank based on their compliance. How do I set up ranking in Power Bi desktop?
Create a new Measure as
Sum of Admin_Fee_Delta=sum('New Lease'[Admin_Fee_Delta])
and Create a new measure as
Admin_Rank = RANKX(ALL('New Lease'[Region]),'New Lease'[Sum of Admin_Fee_Delta],,DESC)
I hope it would work.
10 Replies
Hi Anonymous,
It's hard to provide the detailed solution without sample table, you'd better share sample table and list expected result for further analysis. For ranking, we usually use RANKX function.
Best Regards,
Angelia@Angelia, Ok so being more specfic, I have a bunch of regions that all have delta's and I want to rank them by the sum of that delta. So I have a table built that has Region, then my delta, then my rank of that delta but I keep getting 1 for all my ranks. I am not sure what I am doing wrong. This is my measure, please let me know what Iam doing wrong or what I need to change. Thank you so much!
Admin_Rank = rankx(filter(all('New Lease'),'New Lease'[Admin_Fee_Delta]),CALCULATE(sum([Admin_Fee_Delta])),0)
Anonymous
I think this would help you.
Dax Function: Admin Rank = RANKX(ALL(Sheet1[Region]),Sheet1[Sum of Admin_Fee_Delta],,DESC)
