Measure to sum all values of previous months is not working, not accumulating

[julsr]

Hello everyone.

I have one field that calculates the value month by month, and I'm using it on a Line and Clustered Chart. With this code, I want to see a Cumulative line that increases each month (i.e., January = 200, February = January + 100-->300, March = January + February + 1432-->1732, etc.).

I'm using the following code, but the values are not accumulating month by month.

TotalCumulative =
CALCULATE(
SUM(totals[AMOUNTS]),

REMOVEFILTERS(dataTable1[Date],dataTable1[month],dataTable1[year],dataTable1[month_name]),

DATESMTD(DatesTable[Date]),

TREATAS(
VALUES(dataTable1[TYPEACC]),
totals[service_type]
)
)

What measure could I use? 

Note: The 3 tables used in the code are joined and are needed.

[rajendraongole1 · Accepted solution]

Hi @julsr - can you try the below measure

TotalCumulative =
CALCULATE(
SUM(totals[AMOUNTS]),
FILTER(
ALL(DatesTable[Date]),
DatesTable[Date] <= MAX(DatesTable[Date])
),
TREATAS(
VALUES(dataTable1[TYPEACC]),
totals[service_type]
)
)

Hope it works, if not please share  sample data for reference and further analyses