Forum Discussion
Solved
Breaking a tie issue
Good day, I need help with the ranking measure below. It's not able to break the tie when two branches have a tie on Variance % and the underlying values (sumGroups/sumBudget) for Variance % are...
To calculate Rank you can try:
RankBranch =
RANKX(
ALL('YourTable'),
CALCULATE(
[Variance%] +
DIVIDE([sumGroups], 1000000) +
DIVIDE([sumPO], 1000000000000)
),
,
DESC,
DENSE
)This should break ties in the desired manner. Let me know if it works for your scenario!
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
To calculate Rank you can try:
RankBranch =
RANKX(
ALL('YourTable'),
CALCULATE(
[Variance%] +
DIVIDE([sumGroups], 1000000) +
DIVIDE([sumPO], 1000000000000)
),
,
DESC,
DENSE
)
This should break ties in the desired manner. Let me know if it works for your scenario!
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Thank you very much Kedar_Pande
It works! I only had to add * 1000 to the Variance % measure as the measure seemed to not read decimals correctly.