https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RANKX-with-RAND-to-break-ties-does-not-work/m-p/3051501#M105118 <P>Anonymous</LI-USER> , refer </P> <P>Rank Tie breaker <BR /><A href="https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655" target="_blank">https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655</A><BR /><A href="https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/" target="_blank">https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/</A></P> Tue, 31 Jan 2023 02:05:07 GMT amitchandak 2023-01-31T02:05:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RANKX-with-RAND-to-break-ties-does-not-work/m-p/3050562#M105056 <P>Hello,</P><P>I have a problem trying to break ties in a RANKX function using RAND().</P><P>Here is my measure without RAND :</P><DIV><DIV><SPAN>TOP_5_Profession_M_norand = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Infos_Devis_AFN</SPAN><SPAN>[Profession]</SPAN><SPAN>),</SPAN><SPAN>[NB_AFN_M]</SPAN><SPAN>)</SPAN></DIV></DIV><P>Works fine : but I need to break ties so i'm adding +RAND() to [NB_AFN_M] to get [NB_AFN_M_rand] and then:</P><DIV><DIV><SPAN>TOP_5_Profession_M = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Infos_Devis_AFN</SPAN><SPAN>[Profession]</SPAN><SPAN>),</SPAN><SPAN>[NB_AFN_M_rand]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV></DIV><P>But this is not working at all, every time I refresh the visual, i get different values and i do not understand why...</P><P><img /></P><P>&nbsp;</P><P>Could someone helps me to understand why ?</P><P>&nbsp;</P> Mon, 30 Jan 2023 14:09:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RANKX-with-RAND-to-break-ties-does-not-work/m-p/3050562#M105056 Anonymous 2023-01-30T14:09:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RANKX-with-RAND-to-break-ties-does-not-work/m-p/3051501#M105118 <P>Anonymous</LI-USER> , refer </P> <P>Rank Tie breaker <BR /><A href="https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655" target="_blank">https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655</A><BR /><A href="https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/" target="_blank">https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/</A></P> Tue, 31 Jan 2023 02:05:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RANKX-with-RAND-to-break-ties-does-not-work/m-p/3051501#M105118 amitchandak 2023-01-31T02:05:07Z