Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Using Rank with using Measure

I need to using RANK on a measure I created. I this possible?

 

Want to RANK my measure: mYTDRevenue

 

Based on my field: Cost Center (from my BusinessUnit table)

 

Thanks for any help,

 

Z

1 ACCEPTED SOLUTION

@Anonymous

 

It Could be something like this

 

RANK MEASURE=
RANKX ( ALLSELECTED ( BusinessUnit[Cost Center] ), [mYTDRevenue],, DESC, DENSE )

View solution in original post

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

Maybe, can you provide a sample of source data, calculations for your measures and expected output?

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thanks for replying Greg, much appreciated.  I will try to get that - it is hard with the proprietary data / model.     

 

In the meantime can you tell me if it should at least be possible to use Rank based on a measure.

 

Z

@Anonymous

 

It Could be something like this

 

RANK MEASURE=
RANKX ( ALLSELECTED ( BusinessUnit[Cost Center] ), [mYTDRevenue],, DESC, DENSE )
Anonymous
Not applicable

Thanks!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.