The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to 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.
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.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |