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
az38's avatar
az38
Community Champion
6 years ago

Hi a4 

first, try to debug it.

remove ALLSELECTED('salesorderdetails') and check performance

then remove VALUES('salesorderdetails'[Trim name]) and check performance

in order to find the biggest memory consumer.

then we can try to suggest smth.