How to start cumulative measure from zero

[jack10063]

Hi,

I have tried to create a DAX measure that calculates cumulative market value change. It is working nicely except for the first date. I have data for years 2013, 2014 and 2015 and if I use slicer to get only change for 2015 the starting value for this measure includes also changes from years 2013 and 2014. See below current measure below:

=CALCULATE([cf_market_value_change];FILTER(ALL(SystemDate[Date]);SystemDate[Date]<=MAX(SystemDate[Date])))

br,
Jack

 

[scottsen]

Can you try changing your ALL to an ALLSELECTED and see if that gives what you want?

 

[jack10063]

Can you try changing your ALL to an ALLSELECTED and see if that gives what you want?

That's it!! thanks a lot!

br,
Jack