Forum Discussion
How to do Ranking
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.
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)
I get an error using that verbage and I copied directly.
To get a result this is what I had to change it to
Admin_Rank = RANKX(ALL('New Lease'[Region]),sum('New Lease'[Admin_Fee_Delta]),0)
And everything is still 1 for the ranking
Look into this report, you may get the exact understanding.