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 ,

 

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