Breaking a ranking tie

Question

Good dayPlease help with breaking a rank tie.&nbsp;I have Ranking measure and Variance measure. When I have a tie, like&nbsp; Disobothla and Taung below; I then want to use Variance as second measure in order to break the tie. Meaning Taung, should be ranked 7 as it has a smaller variance i.e. It is only 9% over budget, as compared to Disobothla which is 11% over budget.&nbsp; The reason why they are ranking the same is because my Ranking is based on TotalRank which is 3 measures namely; VarianceRank + dropoutRank + PAR%Rank.&nbsp;Also I must mention that all the 3 measures are coming from 3 separate tables and are all linked to Branch details table.The solutions that I see on the community are not resolving my problem.&nbsp;Below are my measures:&nbsp;1. Ranking:&nbsp;IF (&nbsp; &nbsp; ISBLANK ([TotalRank] &nbsp;) = FALSE (),&nbsp; &nbsp; RANKX (&nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED ( 'Centre details'[Branch Description] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [TotalRank] &nbsp;&lt;&gt; BLANK ()&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [TotalRank] ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT ( 'Centre details', 'Centre details'[Branch Description] )&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; ASC,&nbsp; &nbsp; &nbsp; &nbsp; DENSE&nbsp; &nbsp; )) 2. Variance:var _groups = sum(Groups[NR of Groups])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var _budget = sum(Budgets[Budget])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var _diff = &nbsp;_groups - _budget&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return IF(ISBLANK([countBranch]), BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; divide(_diff, _budget))&nbsp;Thank you in advanceMatlotlo&nbsp;&nbsp;

mlsx4 · Answer

Hi&nbsp;Tlotly&nbsp;&nbsp;This post explains perfectly how to break a tie using a second column:&nbsp;https://community.fabric.microsoft.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655&nbsp;Or you can take a look at this solution:https://community.fabric.microsoft.com/t5/Desktop/RANKX-using-a-second-value-to-break-tiebreaker-TOP-N-returns/td-p/1675467&nbsp;

Forum Discussion

Breaking a ranking tie

1 Reply

Related content

RankX Tie Break Alphabetically

Breaking a tie issue

Duplicate ranking

RANKX tie break

Category and Subcategory TOP 5 Rank without Tie Break