Forum Discussion
Solved
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 i...
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.
mdaatifraza5556
Super User
Super UserHi 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.