topic Re: Rank based on 2 indicators in DAX Commands and Tips

Rank based on 2 indicators

majid154a — Tue, 09 Jul 2024 11:34:13 GMT

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 the target order time is 36 minutes.

How can I rank the drivers to get the top 5 who perform well?

Attached is an example of the data.

Thank you.

Driver	Number of Orders	Average total order time
1	132	44
2	106	42
3	116	34
4	146	43
5	112	30
6	123	31
7	106	36
8	123	39
9	119	35
10	129	33
11	147	40
12	118	36
13	132	45
14	126	39
15	110	36
16	122	41
17	114	44
18	141	31
19	116	37
20	127	34
21	125	30
22	142	43
23	124	38
24	106	37
25	107	44
26	109	38
27	132	38
28	140	31
29	131	39
30	119	45
31	134	44
32	101	41
33	102	44
34	118	38
35	123	43
36	144	42
37	131	41
38	147	31
39	135	44
40	121	40

Re: Rank based on 2 indicators

majid154a — Tue, 09 Jul 2024 12:33:33 GMT

Anonymous

Re: Rank based on 2 indicators

ThxAlot — Tue, 09 Jul 2024 19:04:01 GMT

Make it dynamic

Re: Rank based on 2 indicators

majid154a — Wed, 10 Jul 2024 05:14:15 GMT

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>

Re: Rank based on 2 indicators

ThxAlot — Wed, 10 Jul 2024 10:09:19 GMT

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 )