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 ,

 

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

 

 

 

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