How to create TotalYTD that not change by date filter

[Busno]

Hi everyone,

I have a problem. how can I sum number between 1 Jan 2020 - 31 Dec 2020 that not change by date filter.

on my table, I have a fixed column and a column that change by date filter.

Country	Jan 2020- Dec 2020	2021 Selected month
A
B
C
D
E

Help

Thank You

[amitchandak · Accepted solution]

@Busno , Try like.  Use a date table

calculate(sum(Table[Value]), filter(all(Date), date[Date] >= date(2020,01,01) && date[Date] <= date(2020,12,31) ))

[Busno]

@amitchandak 

It's work. !!

Thank you so much