topic RankX Ranking same values as same rank in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RankX-Ranking-same-values-as-same-rank/m-p/2954691#M98124 <P>Good Day,<BR /><BR />I am getting duplicate rankings when they have the same value. In this case its zeros. Is there a way to get it to represent 1,2 and 3 instead of 1,1,1?<BR /><BR /><BR /></P><DIV><DIV><SPAN>Pro Audit Rank =</SPAN></DIV><DIV><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>System_Users</SPAN><SPAN>),</SPAN><SPAN>Audit</SPAN><SPAN>[SUM Pro Audit]</SPAN><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 07 Dec 2022 17:35:52 GMT Anonymous 2022-12-07T17:35:52Z RankX Ranking same values as same rank https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RankX-Ranking-same-values-as-same-rank/m-p/2954691#M98124 <P>Good Day,<BR /><BR />I am getting duplicate rankings when they have the same value. In this case its zeros. Is there a way to get it to represent 1,2 and 3 instead of 1,1,1?<BR /><BR /><BR /></P><DIV><DIV><SPAN>Pro Audit Rank =</SPAN></DIV><DIV><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>System_Users</SPAN><SPAN>),</SPAN><SPAN>Audit</SPAN><SPAN>[SUM Pro Audit]</SPAN><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 07 Dec 2022 17:35:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RankX-Ranking-same-values-as-same-rank/m-p/2954691#M98124 Anonymous 2022-12-07T17:35:52Z Re: RankX Ranking same values as same rank https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RankX-Ranking-same-values-as-same-rank/m-p/2955508#M98174 <P>Anonymous</LI-USER> , Power bi measure rank is dependent on what you have used in visual to if created rank on table System_Users column coming from any other table will redistribute the rank </P> <P>&nbsp;</P> <P>RANKX(ALL(System_Users),Audit[SUM Pro Audit])</P> <P>&nbsp;</P> <P>RANKX(ALL(System_Users[Full Name], System_Users[MVR Branch],System_Users[Entity Name]),Audit[SUM Pro Audit])</P> <P>&nbsp;</P> <P>refer</P> <P>Power BI Rank Across dimension tables: <A href="https://youtu.be/X59qp5gfQoA" target="_blank">https://youtu.be/X59qp5gfQoA</A></P> Thu, 08 Dec 2022 03:43:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/RankX-Ranking-same-values-as-same-rank/m-p/2955508#M98174 amitchandak 2022-12-08T03:43:27Z