https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum-performance/m-p/312839#M156512 <P>i'm using power BI desktop for calculate a cumulative sum froma about 120,000 Rows, but the performance it's very bad.&nbsp; Took about 5 minutes to fill about 15G of ram and couldnt finish.&nbsp; im using this dax to calculate the acumuluative total</P><P>&nbsp;</P><P>Cumulative Quantity =<BR />CALCULATE (<BR />SUM ( 'Sales SalesOrderDetail'[LineTotal] ),<BR />FILTER (<BR />ALL ( 'Table' ),<BR />'Table'[Index] &lt;= MAX ( 'Table'[Index] )<BR />)<BR />)</P><P>&nbsp;</P><P>Any ideas how to make more faster or efficient a acumulative sum with more than 30,000 rows?&nbsp; if i test for example with 20000 this works well but above 30000 isnt work.</P> Tue, 28 Nov 2017 16:04:43 GMT juanbizzz 2017-11-28T16:04:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum-performance/m-p/312839#M156512 <P>i'm using power BI desktop for calculate a cumulative sum froma about 120,000 Rows, but the performance it's very bad.&nbsp; Took about 5 minutes to fill about 15G of ram and couldnt finish.&nbsp; im using this dax to calculate the acumuluative total</P><P>&nbsp;</P><P>Cumulative Quantity =<BR />CALCULATE (<BR />SUM ( 'Sales SalesOrderDetail'[LineTotal] ),<BR />FILTER (<BR />ALL ( 'Table' ),<BR />'Table'[Index] &lt;= MAX ( 'Table'[Index] )<BR />)<BR />)</P><P>&nbsp;</P><P>Any ideas how to make more faster or efficient a acumulative sum with more than 30,000 rows?&nbsp; if i test for example with 20000 this works well but above 30000 isnt work.</P> Tue, 28 Nov 2017 16:04:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/cumulative-sum-performance/m-p/312839#M156512 juanbizzz 2017-11-28T16:04:43Z