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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

a4 , Try like

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

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

Hi Amit,

This formula doesn't give the desired result. All the ranks are same.

 

Kind Regards

Amit Kumar