Forum Discussion
Need help with ranking expression
Hi dmoney7612 ,
You can refer to this article about ranking in power bi.
Since there is no data model, it is suggested to try
Pref Supplier Rank = RANKX (ALLSELECTED('EC Hierarchy'),[ADS % Growth],,ASC,Dense)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dmoney7612 you have to share using one drive/google drive. You cannot attach to the post.
I'm not comfortable doing that. I thought I already explained it pretty well but I will say it again. The measure that I am trying to rank (ADS % Growth) is already a calculated measure and is not supported by the CALCULATE(SUM( DAX expression. I simply want the below percentages to be ranked appropriately (so the 333.86% would be ranked 1, the 230.68% ranked 2, etc. This is the DAX expression I currently have:
Again, CALCULATE(SUM( does not seem to appropriate in this scenario
Hi dmoney7612 ,
You can refer to this article about ranking in power bi.
Since there is no data model, it is suggested to try
Pref Supplier Rank = RANKX (ALLSELECTED('EC Hierarchy'),[ADS % Growth],,ASC,Dense)Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked much appreciated!