the cumulative value in a line chart is not filtering values correctly

[sv00001]

Hi,

I have created a cumulative line using the below measure.

CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Date] <= MAX('Table[Date])))

this is working fine.

but when I filter specific value from a column as filter which is from same table the cumulative value is not changing.

Can anyone help me with this.

[Ritaf1983 · Accepted solution]

Hi @sv00001 
This happens because you used the "All" function on a table level, this function removed all of the filters from the table.
Try to modify it to :
CALCULATE(SUM('Table'[value]),FILTER(allsellected('Table'[date]),'Table'[Date] <= MAX('Table[Date])))

more information about cumulative total with slicers is here

https://www.youtube.com/watch?v=snQhmAxnIYA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly