Forum Discussion

a4's avatar
a4
Helper III
6 years ago

How to optimize the RANKX measure

Hi all   I have a  rank measure:   Rank  = CALCULATE( RANKX(ALL('salesorderdetails'[Trim name]),ROUND([Gross Premium(USD) minus Commission (USD)],2),,DESC,Dense),ALLSELECTED('salesorderdetails')...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI a4 ,

 

Share sample .pbix and screen shot of your table and vizualisation.

 

Also you can try this

RANKX(ALLSELECTED('salesorderdetails'[Trim name]),CALCULATE(ROUND([Gross Premium(USD) minus Commission (USD)],2)),,DESC,Dense)

 

Regards,

Harsh Nathani

a4's avatar
a4
Helper III
6 years ago

Hi Harsh,
This formula also didn't work.Please find a acreenshot for better understanding

 

[Gross Premium(USD) minus Commission (USD)] (Which is used in rank measure) = Net Premium (USD)

 

 

Please suggest a better formula for optimization.

 

Kind Regards

Amit Kumar

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi a4 ,

     

    What was the output of the above formula.

     

    Not sure why this is not working. Maybe something to do with measures.

     

    RANK = RANKX(ALL(Salesorderdetails),ROUND([Gross Premium(USD) minus Commission (USD)],2)),,DESC,Dense)

     

    Regards,

    Harsh Nathani

    • a4's avatar
      a4
      Helper III
      6 years ago

      Hi Harsh,

      The formula which I have used gives the correct result, the only problem is that it is not optimized.

      Please refer my first post for the formula.

       

      Kind Regards

      Amit Kumar