how to make visualization of running total stop at certain date

[Fabrizio]

Hi

i would like to show a cumulative value for 2020 only (01.01.20 - 31.01.2020) and a cumulative value starting from 2021 (into 2022 and ongoing) 

I could calculate both, but in the visualization the 2020 value keeps going on. I could not find a way to make it end at 31.12.2020. 

Running Total 2020= (not working as expected)
CALCULATE([MEASURE],

FILTER(ALLSELECTED('Date'), 'Date'[Date] <= MAX('Date'[Date])), 'Date'[Year]=2020)

Running Total 2021+ (this one is working as expected)

CALCULATE([MEASURE],

FILTER(ALLSELECTED('Date'), 'Date'[Date] <= MAX('Date'[Date])), 'Date'[Year]>2020)

any idea how i could fix this? 

I also tried with some IF statements, but failed 🙂 

Thank you in advance. 

[Fabrizio]

@Greg_Deckler  working perfect! 

Thanks a lot!

[Greg_Deckler · Accepted solution]

@Fabrizio Maybe:

Running Total 2020 =
  VAR __Date = MAX('Date'[Date])
RETURN
  IF(__Date > DATE(2020,12,31), BLANK(),CALCULATE([MEASURE],
FILTER(ALLSELECTED('Date'), 'Date'[Date] <= MAX('Date'[Date])), 'Date'[Year]=2020))