Cumulative Total only shows the last number

[yennhi95zz]

Hi,

I've check relationship everything but do not get what makes it wrong. I want the cumulative total for each month but this only shows the final number:

Hope anyone could clarify my confusion. Thank you

[yennhi95zz · Accepted solution]

Thanks guys. I don't really know why it does not work. But I have an alternative way. Instead of using FILTER (ALL ( ... ) etc, I will use DATESYTD like this 

[Tahreem24]

@yennhi95zz , I created my own sample to calculate running total and it's working fine.

[amitchandak]

@yennhi95zz , have tried water wall visual for that

one way is

M1= SUM(Sales[Sales Amount])

M2 = CALCULATE([M1],filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))//means cumm till last month

Now if you plot these two and make m2 as white you will reach till last month

Or use M3 in place of M1

M3 =

var _max = maxx(allselected('Date') ,'Date' [Date]))

return

if( max('Date' [Date]) = _max,  CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date])))  , [M1] )

Cumm on M1 in last month

M4 =

var _max = maxx(allselected('Date') ,'Date' [Date]))

return

if( max('Date' [Date]) = _max, blank(), [M2])

use M3 and M4 in visual with m4 as white and try