Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
@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)
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.
The link is opening a page and I log in but it never loads.
Why in your version are you using sheet1 and why will mine not accpet that? Same with desc?
Make sure that the Rank is Measure in your report.
That is what I am trying to create with my formula, the rank...am I missing a step before this one?
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.
It worked, thank you so much!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |