topic Re: How to show a ranking in a ranking in DAX? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3082914#M107541 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315349" data-lia-user-login="MarcoW91" class="lia-mention lia-mention-user">MarcoW91</a>&nbsp;<BR />Better to have a Year (intiger data type) column. However, worth to try the following</P> <LI-CODE lang="javascript">Total = RANKX ( CALCULATETABLE ( InputData, ALLEXCEPT ( InputData, InputData[Grp cust name], InputData[DateYear].[Year] ) ), CALCULATE ( SUM ( [Net Invoiced] ) ), , DESC, DENSE )</LI-CODE> <P>I guess even the .[Year] part won't be required:</P> <LI-CODE lang="javascript">Total = RANKX ( CALCULATETABLE ( InputData, ALLEXCEPT ( InputData, InputData[Grp cust name], InputData[DateYear] ) ), CALCULATE ( SUM ( [Net Invoiced] ) ), , DESC, DENSE ) </LI-CODE> Thu, 16 Feb 2023 08:26:42 GMT tamerj1 2023-02-16T08:26:42Z How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081580#M107430 <P>I want to see the top 20 customers [Grp cust name] per [DateYear].[Year] based on [Net Invoiced] How can I show such a ranking per year? I currently have this, but I am unable to manage to get a yearly ranking:</P><P>&nbsp;</P><DIV><DIV><SPAN>Total = </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>InputData</SPAN><SPAN>,</SPAN><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>SUM</SPAN><SPAN>( </SPAN><SPAN>[Net Invoiced]</SPAN><SPAN>), </SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>( </SPAN><SPAN>InputData</SPAN><SPAN>, </SPAN><SPAN>InputData</SPAN><SPAN>[Grp cust name]</SPAN><SPAN> )),,</SPAN><SPAN>DESC</SPAN><SPAN>,</SPAN><SPAN>DENSE</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can someone help please?</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you kindly!</SPAN></DIV></DIV> Wed, 15 Feb 2023 14:27:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081580#M107430 MarcoW91 2023-02-15T14:27:20Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081612#M107434 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315349" data-lia-user-login="MarcoW91" class="lia-mention lia-mention-user">MarcoW91</a>&nbsp;</P><P>you would need a year column, then try to add calculated column like:</P><LI-CODE lang="markup">Total = RANKX( VALUES(InputData[Year]), CALCULATE( SUM( [Net Invoiced]), ALLEXCEPT( InputData, InputData[Grp cust name] )), , DESC, DENSE )</LI-CODE> Wed, 15 Feb 2023 14:43:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081612#M107434 FreemanZ 2023-02-15T14:43:24Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081631#M107438 <P>Hi FreemanZ, thank you for your answer but I only get 1's out of it:</P><P>&nbsp;</P><DIV><DIV><SPAN>Total = </SPAN></DIV><DIV><SPAN>RANKX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN>(InputData[DateYear]</SPAN><SPAN>.</SPAN><SPAN>[Year]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>SUM</SPAN><SPAN>( [Net Invoiced]), </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>( InputData, InputData[Grp cust name] )),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DESC</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; DENSE</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV> Wed, 15 Feb 2023 14:50:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081631#M107438 MarcoW91 2023-02-15T14:50:42Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081641#M107441 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315349" data-lia-user-login="MarcoW91" class="lia-mention lia-mention-user">MarcoW91</a>&nbsp;</P><P>are you creating a measure? If so, what context do you have?</P> Wed, 15 Feb 2023 14:56:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081641#M107441 FreemanZ 2023-02-15T14:56:32Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081678#M107443 <P>I am creating a column with dax as I would need to rename all items which are 20+ to the other category (I am wondering if it is also possible to create another subranking with [Plant ID]</P> Wed, 15 Feb 2023 15:28:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081678#M107443 MarcoW91 2023-02-15T15:28:31Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081764#M107453 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315349" data-lia-user-login="MarcoW91" class="lia-mention lia-mention-user">MarcoW91</a>&nbsp;</P><P>try like:</P><DIV>Total =&nbsp;</DIV><DIV>RANKX<SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; FILTER(</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;InputData,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; YEAR(InputData[DateYear]) = YEAR(EARLIER(InputData[DateYear]))<BR /></SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),<BR /></SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE( SUM( [Net Invoiced]),&nbsp;</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>&nbsp;,</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp; &nbsp;DESC,</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp; &nbsp;DENSE</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>in case of issue, please consider paste your sample dataset with expected result column.</SPAN></DIV> Wed, 15 Feb 2023 15:44:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3081764#M107453 FreemanZ 2023-02-15T15:44:30Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3082882#M107536 <P>Unfortunately it doesn't work. Here is the dataset which I modified, the idea is that I always will get the top 19 customers where the others are being classified as other. There are dateyear filters, plant filters and country filters and I would like to show the top 20 based on the filter applied. Would you be able to assist</P><TABLE><TBODY><TR><TD>Calendar Year</TD><TD>Calendar month</TD><TD>Sold-to party</TD><TD>Name</TD><TD>..Groupcustomer</TD><TD>Grp cust name</TD><TD>Country Ship-to-part</TD><TD>..High Mkt. Ship-to</TD><TD>Area</TD><TD>Plant</TD><TD>Company</TD><TD>Material</TD><TD>Product</TD><TD>..SPG-code</TD><TD>Product desc</TD><TD>..SubSubsegment</TD><TD>Product group</TD><TD>Act Invoiced Qty BUM</TD><TD>Act. Weight in KG</TD><TD>Net Invoiced</TD><TD>SGE BU</TD><TD>Act. CON BU</TD><TD>Act. Productcost Grp</TD><TD>Act. Accrd LoadgCost</TD><TD>Act. Accrd PickgCost</TD><TD>Act. Accrued Freight</TD><TD>DateYear</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2020</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Tuesday, September 1, 2020</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2022</TD><TD>9</TD><TD>23</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Netherlands</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Thursday, September 1, 2022</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>34</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>34</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>34</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>34</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2022</TD><TD>9</TD><TD>34</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Thursday, September 1, 2022</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>40</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>40</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>40</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2021</TD><TD>9</TD><TD>71</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Wednesday, September 1, 2021</TD></TR><TR><TD>2021</TD><TD>9</TD><TD>71</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Wednesday, September 1, 2021</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>71</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>71</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR><TR><TD>2018</TD><TD>9</TD><TD>71</TD><TD>X</TD><TD>00000000001</TD><TD>X</TD><TD>Germany</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>X</TD><TD>1111111</TD><TD>X</TD><TD>1234</TD><TD>X</TD><TD>NNN</TD><TD>X</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>1.00</TD><TD>Saturday, September 1, 2018</TD></TR></TBODY></TABLE> Thu, 16 Feb 2023 08:11:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3082882#M107536 MarcoW91 2023-02-16T08:11:53Z Re: How to show a ranking in a ranking in DAX? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3082914#M107541 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315349" data-lia-user-login="MarcoW91" class="lia-mention lia-mention-user">MarcoW91</a>&nbsp;<BR />Better to have a Year (intiger data type) column. However, worth to try the following</P> <LI-CODE lang="javascript">Total = RANKX ( CALCULATETABLE ( InputData, ALLEXCEPT ( InputData, InputData[Grp cust name], InputData[DateYear].[Year] ) ), CALCULATE ( SUM ( [Net Invoiced] ) ), , DESC, DENSE )</LI-CODE> <P>I guess even the .[Year] part won't be required:</P> <LI-CODE lang="javascript">Total = RANKX ( CALCULATETABLE ( InputData, ALLEXCEPT ( InputData, InputData[Grp cust name], InputData[DateYear] ) ), CALCULATE ( SUM ( [Net Invoiced] ) ), , DESC, DENSE ) </LI-CODE> Thu, 16 Feb 2023 08:26:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-a-ranking-in-a-ranking-in-DAX/m-p/3082914#M107541 tamerj1 2023-02-16T08:26:42Z