https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2561667#M72894 <P>Hi, you could create a TOP N filter on the visual itself.</P> Mon, 06 Jun 2022 16:07:56 GMT milanpasschier2 2022-06-06T16:07:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2561520#M72885 <P>Dear All,</P><P>&nbsp;</P><P>Your help with or advice on the subject would be highly appreciated:</P><P>&nbsp;</P><P>I have this measure that is extremely slow:</P><P>&nbsp;</P><P>It takes up to 30 seconds to load the visual (Line and stacked column chart)</P><DIV><P>&nbsp;</P><UL><LI><DIV><DIV><SPAN>Pareto Chart Materials = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>MatGP</SPAN><SPAN> = </SPAN><SPAN>[Total Gross Profit]</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>AllProfit</SPAN><SPAN> = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Total Gross Profit]</SPAN><SPAN>, </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Customer Profitability (Margins)'</SPAN><SPAN>) )</SPAN></DIV><BR /><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>DIVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>SUMMARIZE</SPAN><SPAN>( </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Customer Profitability (Margins)'</SPAN><SPAN>), </SPAN><SPAN>'Customer Profitability (Margins)'[Material]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>"GP"</SPAN><SPAN> , </SPAN><SPAN>[Total Gross Profit]</SPAN><SPAN> ) ,</SPAN></DIV><DIV><SPAN>[GP]</SPAN><SPAN> &gt;= </SPAN><SPAN>MatGP</SPAN><SPAN> ) ,</SPAN></DIV><DIV><SPAN>[GP]</SPAN><SPAN> ) ,</SPAN></DIV><DIV><SPAN>AllProfit</SPAN><SPAN> , </SPAN><SPAN>0</SPAN><SPAN> )</SPAN></DIV></DIV></LI></UL><DIV>&nbsp;</DIV><DIV>&nbsp;Any suggestion as to how to tweak this to make faster?</DIV><DIV>&nbsp;</DIV><DIV>Thank you in advance.</DIV></DIV> Mon, 06 Jun 2022 15:10:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2561520#M72885 Giorgi1989 2022-06-06T15:10:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2561667#M72894 <P>Hi, you could create a TOP N filter on the visual itself.</P> Mon, 06 Jun 2022 16:07:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2561667#M72894 milanpasschier2 2022-06-06T16:07:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2562854#M72952 <P>Hi, thank you for the reply. I could in theory, but I don't think that would be something optimal for my situation.&nbsp;</P> Tue, 07 Jun 2022 06:18:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-is-extremely-slow-Takes-up-to-30-seconds-to-load-the/m-p/2562854#M72952 Giorgi1989 2022-06-07T06:18:04Z