Forum Discussion

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')...

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

a4
Helper III
6 years ago
Hi Harsh,
The formula which you mentioned doesn't give the desired result.All the Trim Name has rank with this formula.
Please suggest anything else.

Kind Regards
Amit Kumar
- a4
  Helper III
  6 years ago
  Hi Harsh,
  The formula which you mentioned doesn't give the desired result.All the Trim Name has the same rank with this formula.
  Please suggest anything else.
  
  Kind Regards
  Amit Kumar
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
- a4
  Helper III
  6 years ago
  Hi Harsh,
  This formula also didn't work.Please find a acreenshot for better understanding
  
  [Gross Premium(USD) minus Commission (USD)] (Which is used in rank measure) = Net Premium (USD)
  
  Please suggest a better formula for optimization.
  
  Kind Regards
  Amit Kumar
  - 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