Ranking

[Resolver]

Hello,

Having an issue with ranking my top routes by Total Orders.

For now there is a summarized table with data that goes to visuals, ranking is based on two things: first by order count, second if there are same values, ranking takes total revenue, but final result seem to have an issue, since there are two 4th places.

Adding snips:

[mdaatifraza5556 · Accepted solution]

Hi @Resolver 

Can you please try the below DAX.

Route Rank =
RANKX(
ALL('Routes'[Route Name]),
CALCULATE(SUM('Orders'[Total Orders]) * 1000000 + SUM('Orders'[Total Revenue])),
,
DESC,
Dense
)


If this answers your questions, kindly accept it as a solution and give kudos.