topic Re: Problems with DAX RankX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063729#M105997 <P>PERFECT!</P><P>Now please explain why that works <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Mon, 06 Feb 2023 12:13:55 GMT GWoodhouse 2023-02-06T12:13:55Z Problems with DAX RankX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063717#M105995 <P>I have a table containing Country names and Priority Orders</P><P>Country Priority</P><P>UK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>NL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2</P><P>&nbsp;</P><P>and another table containing a measure that sums a value</P><P>What I want is</P><P>Rank&nbsp; &nbsp; Priority&nbsp; Country&nbsp; &nbsp;SumofValue</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 900</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 800</P><P>&nbsp;</P><P>But what I am getting is the following because it's ranking by country within the Priority groups</P><P>Rank&nbsp; &nbsp; Priority&nbsp; Country&nbsp; &nbsp;SumofValue</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; US&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 900</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 800</P><P>&nbsp;</P><P>My DAX is al follows</P><DIV><DIV><SPAN>Country Rank = </SPAN></DIV><DIV><SPAN>Rankx</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>all</SPAN><SPAN>(Country[CountryName]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; MySumMeasure,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN><SPAN>desc</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,Dense</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Where am I going wrong?</SPAN></DIV><DIV><SPAN>Thanks in advance</SPAN></DIV></DIV> Mon, 06 Feb 2023 12:03:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063717#M105995 GWoodhouse 2023-02-06T12:03:30Z Re: Problems with DAX RankX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063722#M105996 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="510199" data-lia-user-login="GWoodhouse" class="lia-mention lia-mention-user">GWoodhouse</a>&nbsp;</P><P>try like:</P><DIV><SPAN>Country Rank =</SPAN></DIV><DIV><SPAN>Rankx</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp;</SPAN><SPAN>all</SPAN><SPAN>(Country[CountryName]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE[MySumMeasure], ALL(Country[Priority]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN><SPAN>desc</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,Dense</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV> Mon, 06 Feb 2023 12:10:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063722#M105996 FreemanZ 2023-02-06T12:10:55Z Re: Problems with DAX RankX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063729#M105997 <P>PERFECT!</P><P>Now please explain why that works <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Mon, 06 Feb 2023 12:13:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063729#M105997 GWoodhouse 2023-02-06T12:13:55Z Re: Problems with DAX RankX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063741#M105999 <P><SPAN>[MySumMeasure], as a measure, has an implicit CALCULATE, which converts the row context -&nbsp;Priority, to filter context.&nbsp;</SPAN></P> Mon, 06 Feb 2023 12:19:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problems-with-DAX-RankX/m-p/3063741#M105999 FreemanZ 2023-02-06T12:19:20Z