Error when using cumulative sum with activated filters

46Days — Mon, 13 Feb 2023 17:12:40 GMT

I found a solution to my problem but I don't know why the cumulative sum is not working.

I have the following table which brings me some data which I want to add cumulatively, the question is that when filtering is not applying the cumulative sum function.

following the above logic, the table with the filter enabled should look like this

The function I found and am using is the following

Cumulative_Revenue = CALCULATE(SUM('Hoja1 (2)'[Value]), FILTER(ALLSELECTED('Hoja1 (2)'[# Month]), YEAR('Hoja1 (2)'[# Month])=YEAR(MAX('Hoja1 (2)'[# Month]))&&'Hoja1 (2)'[# Month] <= MAX('Hoja1 (2)'[# Month])))

I would appreciate if you can help me to find the error why it is not adding correctly cumulatively with the filter activated.

46Days Tracker

Error when using cumulative sum with activated filters