Using Rank with using Measure

[Anonymous]

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

[Greg_Deckler]

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

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

@Anonymous

It Could be something like this

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

[Anonymous]

Thanks!