Forum Discussion

dmoney7612's avatar
dmoney7612
Icon for Helper II rankHelper II
4 years ago
Solved

Need help with ranking expression

I am trying to create a ranking expression based on average daily sales growth for my account managers. As you can see in the below image, it is not working correctly. The expression I'm using is the...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
dmoney7612
Icon for Helper II rankHelper II
4 years ago

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:

 

Pref Supplier Rank = IF (
HASONEVALUE ( 'EC Hierarchy'[Account Manager]),
RANKX (
ALL ( 'EC Hierarchy'[Account Manager] ),
CALCULATE( [ADS % Growth])))

 

Again, CALCULATE(SUM( does not seem to appropriate in this scenario

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    dmoney7612
    Icon for Helper II rankHelper II
    4 years ago

    This worked much appreciated!