Performance of cummulative measure

[wojcikgp]

Hi!

I struggle with below measure performance. Could you please help me rewrite it, so it doesnt need that much memory?

Its finishes up with "Couldn't load the data for this visual. There is not enough memory to complete this operation. (...)"

Its working on 4.000.000 rows table 'Sales', pbix is 45mb and PowerBI Desktop is a 64bit version.

Sales_DayCummulative =

var LastSalesTime = CALCULATE( MAX( 'Sales'[Time]); All( 'Sales'))

return

IF(

SELECTEDVALUE( 'Sales'[Time]) > LastSalesTime;

BLANK();

CALCULATE(

SUM( 'Sales'[Value]);

FILTER( ALLSELECTED( 'Sales'); 'Sales'[Time] <= MAX ( 'Sales'[Time])

)))

[Greg_Deckler]

I wrote a series on performance tuning DAX, see if it helps: https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275