Forum Discussion
Ranking
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:
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.
1 Reply
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.