Forum Discussion
Need Help About Index
i sorted by index. To double check with your logic, sort by order qty lowest to highest, then order number lowest to highest. Is that correct?
ryan_mayu but i need a new column which index numbers will be as i mentioned , i need the index numbers as i mentioned below picture , lets repeat rules to you too ;
First index number "1" will be given the order which has less total order quantity .
then which order total quantity will be bigger it will get index number "2 "
there can be 2 or maybe 3 line for one order . ın our example all orders has 2 lines , For that situtaions if an order got an index number all line of order will be same .
in our below example "order 350 "and "order 430 " , has equal order quantities , so for this situations system will give priorty for the order which one has smaller order number .
on your examples all lines has different index numbers dear , i just want a index number distrubution as below
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)