Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
Solved

Need Help About Index

Hi there ;   I need your support about to fix my below index  formula , let me explain what the problem :    I have a table which includes "order number" and  "order qty ",as  below :    ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    erhan_79 

    please try this

    rank = 
 RANKX('Table',CALCULATE(SUM('Table'[Order Qty]),ALLEXCEPT('Table','Table'[Order Number])),,ASC,Dense)
+RANKX('Table',VALUE('Table'[Order Number]),,ASC,Dense)/10


rank2 = RANKX('Table',VALUE('Table'[rank]),,ASC,Dense)

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

erhan_79 

please try this

rank = 
 RANKX('Table',CALCULATE(SUM('Table'[Order Qty]),ALLEXCEPT('Table','Table'[Order Number])),,ASC,Dense)
+RANKX('Table',VALUE('Table'[Order Number]),,ASC,Dense)/10


rank2 = RANKX('Table',VALUE('Table'[rank]),,ASC,Dense)

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago

perfect job !  ryan_mayu 

 

thank you very much ! it is working as i want