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,
Go to Solution.
It Could be something like this
RANKX ( ALLSELECTED ( BusinessUnit[Cost Center] ), [mYTDRevenue],, DESC, DENSE )
View solution in original post
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
Proud to be a Super User!
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.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021