Cumulative sum of measure with underlying if statement by date

[meleeisland]

I've been struggling with this cause I don't quite understand how date filtering works.
My original measure has a separated calculation for dates before and after 2022 (it does ( A * B ) if date is < 2022 and only ( A ) if it's >= 2022, nothing more).

When I apply my running total measure to it, it brings an accumulation divided by 2022 aswell, when it should sum the result of the original measure regardless of the year. Other formulas I've tried don't even show the results prior to 2022.

What could I be doing wrong so that it's not all continuously accumulated?

Measure1 =

IF ( MAX ( CALENDAR[Year] ) < 2022 ; AVERAGE ( Table[Rate] ) * CALCULATE ( [AnotherMeasure] ; ALL ( Table ) ) ; [AnotherMeasure] )

Measure2 =

VAR MaxDate = MAX ( CALENDAR[Date] )

VAR Result = CALCULATE ( [Measure1] ; CALENDAR[Date] <= MaxDate ; ALL (CALENDAR) )

RETURN Result

Please help me 😞

Thank you!

[meleeisland]

Thank you for your reply. That table it's just a one column bridge table with categories.
I need to make the historical total sum of Measure1 that is not reseted at any time.

[wdx223_Daniel]

i'm not really get your question.

but, ALL(Table) will remove all the filters of its expanded table, which may includs the filters come from CALENDAR.