Running total

[FZOU]

Hello community,

I need your help lease is such a problem i'm calculating a running total it's work fine but with a weird comportment.

Until the above picture everything is ok but when i move the filter to start from 15/02/2018 the cumul column ignoer the value of 01/02/2018 and start from 1200 like the picture below

my desired result is if i move the slicer is still take the value of previous date like this table below, i need your help and thank you

Sales Date	DemandQt	Cumul
15/02/2018	1200	2200
24/02/2018	1500	3700
15/04/2018	1000	4700
Total	4700	4700

this is my formula : 

Cumul = CALCULATE(SUM(Demand[DemandQt]);FILTER(ALLSELECTED(demand);Demand[Sales Date]<=max(Demand[Sales Date])))

[amitchandak · Accepted solution]

@FZOU 

if you use allselected it will take the selected dates , you can use all or datestyd as per need

Cumul = CALCULATE(SUM(Demand[DemandQt]);FILTER(ALL(demand);Demand[Sales Date]<=max(Demand[Sales Date])))

Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date])

Cumul = CALCULATE(SUM(Demand[DemandQt]);datesytd('Date'[Date],"1/31")// force year from Feb

[FZOU]

@amitchandak  thank you very much for your fast response, it work,i'm still confused with ALL and ALL selected

[amitchandak]

@FZOU , refer this one

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/