https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-max-for-a-calculated-measure-based-on-top-10-products/m-p/3299884#M123046 <P>Anonymous</LI-USER>&nbsp;i hope this helps you !THANK YOU!!<BR />Plot this measure &nbsp;<SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>Sales</SPAN><SPAN>,&nbsp;</SPAN><SPAN>[Declared Stock]</SPAN><SPAN>)</SPAN></P><P><img /></P><P>&nbsp;</P> Fri, 23 Jun 2023 13:36:00 GMT Mahesh0016 2023-06-23T13:36:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-max-for-a-calculated-measure-based-on-top-10-products/m-p/3299220#M122979 <P>Hello,</P><P>&nbsp;</P><P>I have a measure that ranks my products based on sales&nbsp;</P><DIV><DIV><SPAN>Product Rank = </SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN> Ranking =</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(Product[Product]),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>NOT</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(Sales[Quantity]))))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(Sales[Quantity]))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; Ranking</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Another measure that gets the maximum of a calculated measure&nbsp;</SPAN></DIV><DIV><DIV><DIV><SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>Sales</SPAN><SPAN>, </SPAN><SPAN>[Declared Stock]</SPAN><SPAN>) however this measure gets the maximum value of declared in the whole dataset.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I would like to get the maximum but only within the top 10 products, how can I achieve that?</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you!</SPAN></DIV></DIV></DIV></DIV> Fri, 23 Jun 2023 06:44:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-max-for-a-calculated-measure-based-on-top-10-products/m-p/3299220#M122979 Anonymous 2023-06-23T06:44:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-max-for-a-calculated-measure-based-on-top-10-products/m-p/3299884#M123046 <P>Anonymous</LI-USER>&nbsp;i hope this helps you !THANK YOU!!<BR />Plot this measure &nbsp;<SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>Sales</SPAN><SPAN>,&nbsp;</SPAN><SPAN>[Declared Stock]</SPAN><SPAN>)</SPAN></P><P><img /></P><P>&nbsp;</P> Fri, 23 Jun 2023 13:36:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-max-for-a-calculated-measure-based-on-top-10-products/m-p/3299884#M123046 Mahesh0016 2023-06-23T13:36:00Z