Forum Discussion
Assistance with Ranking and Conditional Formatting
Hi atin,
I believe your alomost correct, you can try with below modified DAX.
I would suggest to multiply points by higher factor(10,000 instead of 1000) to reduce chances of key collisions.
1st measure(Modified): RankKey
RankKey =MAX(TeamStats[Points] ) * 10000 +MAX(TeamStats[GD] ) * 100 +MAX(TeamStats[GF] )Make sure the Rank measure evaluates per group per visual row, not with unexpected context.2nd Measure(modified): RANK MEASURE
Rank =VAR _group = SELECTEDVALUE(TeamStats[Group Type])RETURNRANKX(FILTER(ALL(TeamStats ),TeamStats[Group Type] = _group),[RankKey] ,,DESC,Dense),BLANK() )To prevent any BLANK() that might cause formatting issues3rd Measure(modified): HighlightTop2
HighlightTop2 =IF([Rank] <= 2,
"#C6EFCE", // Highlight for top 2
"#FFFFFF" // White (or you can use "transparent")
)Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
Hi atin ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
Your method of ranking teams within each group based on Points, Goal Difference (GD), and Goals For (GF) follows standard tournament rules and makes perfect sense.
After reviewing your measures and visuals, it looks like the issue with conditional formatting is mainly due to:
- The way RankKey is calculated it might create the same value for teams with similar stats.
- The group filter not being applied correctly in your RANKX formula.
- Using BLANK() in the formatting, which can cause display issues.
Also thank you ajaybabuinturi for the response shared, which accurately addresses these points. In particular:
- Using Points * 10,000 in RankKey makes the ranking more accurate.
- Adding a VAR _group in your Rank measure ensures it ranks teams correctly within each group.
- Returning a color like white instead of BLANK() in HighlightTop2 avoids formatting problems in visuals.
These updates should help you highlight the top two teams correctly in each group.
Hope this helps. Please reach out for further assistance.
Thank you.
Hi,
Share the download link of the PBI file and show the expected result there clearly.