https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pareto-Slow/m-p/2548835#M72068 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395486" data-lia-user-login="JaderAlexandre" class="lia-mention lia-mention-user">JaderAlexandre</a> , Try the method suggested by Matt</P> <P><A href="https://exceleratorbi.com.au/pareto-analysis-in-power-bi/" target="_blank">https://exceleratorbi.com.au/pareto-analysis-in-power-bi/</A></P> Tue, 31 May 2022 02:51:14 GMT amitchandak 2022-05-31T02:51:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pareto-Slow/m-p/2547929#M72013 <P>&nbsp;</P><P>Good Morning, I have one big base, when I try accumulate is very slow.&nbsp; Someony help me about improve this perfomance in the accumulate ?</P><P>&nbsp;</P><P>&nbsp;Thank you</P><P>&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>mParetoAuditSomentePareto = </SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>TotalVendas</SPAN><SPAN> = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[VendaTotalPareto]</SPAN><SPAN>,</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>AuditSomenteVendasPareto</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>TotalAtual</SPAN><SPAN> = </SPAN><SPAN>[VendaTotalPareto]</SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>tbResumo</SPAN><SPAN> = </SPAN><SPAN>SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>AuditSomenteVendasPareto</SPAN><SPAN>),</SPAN><SPAN>CADMER[MERCADORIA]</SPAN><SPAN>,</SPAN><SPAN>"Total"</SPAN><SPAN>,</SPAN><SPAN>[VendaTotalPareto]</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>TotalAcumulado</SPAN><SPAN> = </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>tbResumo</SPAN><SPAN>,</SPAN><SPAN>[Total]</SPAN><SPAN> &gt;= </SPAN><SPAN>TotalAtual</SPAN><SPAN>),</SPAN><SPAN>[Total]</SPAN><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>Return</SPAN> <SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>TotalAcumulado</SPAN><SPAN>,</SPAN><SPAN>TotalVendas</SPAN><SPAN>,</SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV></DIV> Mon, 30 May 2022 13:34:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pareto-Slow/m-p/2547929#M72013 JaderAlexandre 2022-05-30T13:34:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pareto-Slow/m-p/2548835#M72068 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="395486" data-lia-user-login="JaderAlexandre" class="lia-mention lia-mention-user">JaderAlexandre</a> , Try the method suggested by Matt</P> <P><A href="https://exceleratorbi.com.au/pareto-analysis-in-power-bi/" target="_blank">https://exceleratorbi.com.au/pareto-analysis-in-power-bi/</A></P> Tue, 31 May 2022 02:51:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Pareto-Slow/m-p/2548835#M72068 amitchandak 2022-05-31T02:51:14Z