Forum Discussion

majid154a's avatar
majid154a
Icon for Helper II rankHelper II
2 years ago
Solved

Rank based on 2 indicators

Dear Experts, With the delivery data, I want to rank the drivers based on two indicators: the largest number of orders and the minimum possible average total order time from all orders. Note that th...
Need Help
majid154a's avatar
majid154a
Icon for Helper II rankHelper II
2 years ago

ThxAlot Thank you alot. Thank you. Thank you.

In your solution, can you exlplain to me this code: 

Rnk = GENERATESERIES( 1, CALCULATE( COUNTROWS( DATA ), DATA[Average total order time] <= 36 ) )
 
Also, we have here top 13 in our example, how If need top 20 or top 30?

Thanks much for hepling> 
  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    2 years ago

    That create a result meeting the requirement of DATA[Average total order time] <= 36; otherwise, you can put an arbitary number as you like,

    Rnk = GENERATESERIES( 1, 100 )