Accumulated sum that resets when the year changes

[req77]

Hello,

I created a measure that counts the total items per month and it's working fine. This is my measure:

Cumulative_Total =

CALCULATE([Qtd_Total],

    FILTER(ALL('Table'),

        'Table'[Date] <= MAX('Table'[Date])

        )

    )

But I want my chart to reset the count when the user selects only one year in the dashboard year filter.
For example: if he selects only the items from 2022, the chart will start from zero in the month of January, and not take the count of the previous months (2021) and add to the months of the year 2022. How can I do this?

[PVO3 · Accepted solution]

Please try to include date to your filters like below.

Or (perhapse better) use ALLSELECTED instead of ALL/ALLEXCEPT.

Cumulative_Total =

CALCULATE([Qtd_Total],

    FILTER(ALLEXCEPT('Table','Table'[Date]),

        'Table'[Date] <= MAX('Table'[Date])

        )

    )