How to optimize the RANKX measure

All forum topics
Previous Topic
Next Topic

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'),VALUES('salesorderdetails'[Trim name]))

When I remove this measure from table visual it brings down the excution time down to 2 seconds and performance is improved. So, clearly there is a problem with the Rank measure.

Please suggest a way to optimize the RANKX function.

Kind Regards

Amit Kumar