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)

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi erhan_79 

That's not the same thing as you first asked for.  You should always supply a proper representation of your data at the start.  I'll look into the problem.

Regards

Phil

  • erhan_79's avatar
    erhan_79
    Post Prodigy
    5 years ago

    You are right PhilipTreacy  ;

     

    i am sorry it was my fault , i forgot to explain all the scenarious  , thank you very much for your kind supports dear .

     

    i will wait for your good news 

     

    thanks 

     

    erhan