topic Re: DAX Measure for Distinct top 3 Fruits per Quarter in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761968#M182366 <P>Create this measure</P><P>&nbsp;</P><DIV><DIV><SPAN>Sales Top&nbsp;</SPAN><SPAN>3</SPAN><SPAN>&nbsp;=</SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN>&nbsp;</SPAN><SPAN>Top3Prod</SPAN><SPAN>&nbsp;=</SPAN></DIV><DIV><SPAN>TOPN</SPAN><SPAN>&nbsp;(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>3</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>ALL</SPAN><SPAN>&nbsp;( Fruit[FruitName]</SPAN><SPAN>&nbsp;),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>[Sales]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(&nbsp;</SPAN><SPAN>[Sales]</SPAN><SPAN>,&nbsp;</SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(&nbsp;</SPAN><SPAN>Top3Prod</SPAN><SPAN>&nbsp;) )</SPAN></DIV></DIV><P>&nbsp;</P><P>put the quarter column (I sugget year-quarter) in Columns and the fruit column in Rows in a matrix</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/273" target="_blank" rel="noopener">@me&nbsp;</A>in replies or I'll lose your thread</STRONG></P><P>consider voting<SPAN>&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank" rel="noopener">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P><DIV class=""><P><A href="https://community.fabric.microsoft.com/t5/Desktop/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761915#M1419530" target="_blank" rel="noopener">View solution in original post</A></P></DIV> Mon, 14 Jul 2025 11:06:23 GMT FBergamaschi 2025-07-14T11:06:23Z DAX Measure for Distinct top 3 Fruits per Quarter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761962#M182365 <P>Hi Community,<BR /><BR />I am seeking assistance in achieving these figures using the DAX measure. Different top 3 fruits should be captured for each quarter. Is it possible? Thank you in advance!<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 14 Jul 2025 11:02:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761962#M182365 xcaliber044 2025-07-14T11:02:54Z Re: DAX Measure for Distinct top 3 Fruits per Quarter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761968#M182366 <P>Create this measure</P><P>&nbsp;</P><DIV><DIV><SPAN>Sales Top&nbsp;</SPAN><SPAN>3</SPAN><SPAN>&nbsp;=</SPAN></DIV><DIV><SPAN>VAR</SPAN><SPAN>&nbsp;</SPAN><SPAN>Top3Prod</SPAN><SPAN>&nbsp;=</SPAN></DIV><DIV><SPAN>TOPN</SPAN><SPAN>&nbsp;(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>3</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>ALL</SPAN><SPAN>&nbsp;( Fruit[FruitName]</SPAN><SPAN>&nbsp;),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;&nbsp;</SPAN><SPAN>[Sales]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(&nbsp;</SPAN><SPAN>[Sales]</SPAN><SPAN>,&nbsp;</SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(&nbsp;</SPAN><SPAN>Top3Prod</SPAN><SPAN>&nbsp;) )</SPAN></DIV></DIV><P>&nbsp;</P><P>put the quarter column (I sugget year-quarter) in Columns and the fruit column in Rows in a matrix</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/273" target="_blank" rel="noopener">@me&nbsp;</A>in replies or I'll lose your thread</STRONG></P><P>consider voting<SPAN>&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank" rel="noopener">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P><DIV class=""><P><A href="https://community.fabric.microsoft.com/t5/Desktop/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761915#M1419530" target="_blank" rel="noopener">View solution in original post</A></P></DIV> Mon, 14 Jul 2025 11:06:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Measure-for-Distinct-top-3-Fruits-per-Quarter/m-p/4761968#M182366 FBergamaschi 2025-07-14T11:06:23Z