topic About sorting data in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784437#M4243 <P>hi all</P><P class="src">&nbsp;</P><P class="src">I had a problem writing RANKX . so here's my RANKX function</P><P class="src">&nbsp;</P><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp;totalCount = SUM(Table1[count])</SPAN></DIV><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp;countRAN = RANKX(ALL(Table1[time]),[totalCount],,ASC)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But here's what I got</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><img /><img /></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>The first image is the result of my table, and the second image is my data</SPAN></SPAN></DIV><DIV><SPAN><SPAN>You can see in the first picture that my RANKX function calculated something wrong with the data</SPAN></SPAN></DIV><DIV><SPAN>Can someone tell me why&nbsp; thinks</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Best Regards</SPAN></DIV><DIV><SPAN>alan-li</SPAN></DIV></DIV></DIV> Thu, 05 Sep 2019 08:37:45 GMT Anonymous 2019-09-05T08:37:45Z About sorting data https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784437#M4243 <P>hi all</P><P class="src">&nbsp;</P><P class="src">I had a problem writing RANKX . so here's my RANKX function</P><P class="src">&nbsp;</P><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp;totalCount = SUM(Table1[count])</SPAN></DIV><DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp;countRAN = RANKX(ALL(Table1[time]),[totalCount],,ASC)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But here's what I got</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><img /><img /></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>The first image is the result of my table, and the second image is my data</SPAN></SPAN></DIV><DIV><SPAN><SPAN>You can see in the first picture that my RANKX function calculated something wrong with the data</SPAN></SPAN></DIV><DIV><SPAN>Can someone tell me why&nbsp; thinks</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Best Regards</SPAN></DIV><DIV><SPAN>alan-li</SPAN></DIV></DIV></DIV> Thu, 05 Sep 2019 08:37:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784437#M4243 Anonymous 2019-09-05T08:37:45Z Re: About sorting data https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784538#M4246 <P>Create a calculated column&nbsp;<BR />RankCount&nbsp; = RANKX(Table,Table[count])</P> Thu, 05 Sep 2019 09:41:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784538#M4246 Anonymous 2019-09-05T09:41:22Z Re: About sorting data https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784557#M4249 <P class="src">hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P class="src">&nbsp;</P><P class="src">It works. Thank you</P><P class="src">&nbsp;</P><P class="src">Best Regards</P><P class="src">alan-li</P> Thu, 05 Sep 2019 09:48:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/About-sorting-data/m-p/784557#M4249 Anonymous 2019-09-05T09:48:52Z