Forum Discussion

a4's avatar
a4
Icon for Helper III rankHelper 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 ,

 

Try this.

Rank =

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

 

Also, if you can share sample data. 

 

Regards,

Harsh Nathani

 

 

 

a4's avatar
a4
Icon for Helper III rankHelper III
6 years ago

Hi Harsh,

The formula which you mentioned doesn't give the desired result.All the Trim Name has rank with this formula.

Please suggest anything else.

 

 

Kind Regards

Amit Kumar

  • a4's avatar
    a4
    Icon for Helper III rankHelper III
    6 years ago

    Hi Harsh,

    The formula which you mentioned doesn't give the desired result.All the Trim Name has the same rank with this formula.

    Please suggest anything else.

     

     

    Kind Regards

    Amit Kumar