topic Calculate Top 5 Brands Based on Manufacturers Rank one manufacturer's brand first compared to other in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2678164#M80084 <P>Can anyone assist me on this?<BR /><BR /></P><DIV><DIV><SPAN>Manu Rank 2 = </SPAN><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>'Actuals Data'[Regional_Manufacturer]</SPAN><SPAN>)=</SPAN><SPAN>"Abc"</SPAN><SPAN>,</SPAN><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp;</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>Calculate</SPAN><SPAN>(</SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Actuals Data'[Regional_Brand]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[SUM OF TOTAL]</SPAN><SPAN>,,,</SPAN><SPAN>Dense</SPAN><SPAN>)))</SPAN></DIV></DIV> Wed, 03 Aug 2022 10:06:12 GMT Anonymous 2022-08-03T10:06:12Z Calculate Top 5 Brands Based on Manufacturers Rank one manufacturer's brand first compared to other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2678164#M80084 <P>Can anyone assist me on this?<BR /><BR /></P><DIV><DIV><SPAN>Manu Rank 2 = </SPAN><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>'Actuals Data'[Regional_Manufacturer]</SPAN><SPAN>)=</SPAN><SPAN>"Abc"</SPAN><SPAN>,</SPAN><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp;</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>Calculate</SPAN><SPAN>(</SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Actuals Data'[Regional_Brand]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[SUM OF TOTAL]</SPAN><SPAN>,,,</SPAN><SPAN>Dense</SPAN><SPAN>)))</SPAN></DIV></DIV> Wed, 03 Aug 2022 10:06:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2678164#M80084 Anonymous 2022-08-03T10:06:12Z Re: Calculate Top 5 Brands Based on Manufacturers Rank one manufacturer's brand first compared to other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2678262#M80090 <P><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Wed, 03 Aug 2022 10:23:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2678262#M80090 stevedep 2022-08-03T10:23:43Z Re: Calculate Top 5 Brands Based on Manufacturers Rank one manufacturer's brand first compared to other https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2754072#M85066 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>Can you provide a sample for us ?&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,<BR />Community Support Team _ Ailsa Tao</P> Thu, 08 Sep 2022 01:47:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Top-5-Brands-Based-on-Manufacturers-Rank-one/m-p/2754072#M85066 Anonymous 2022-09-08T01:47:59Z