Right approach for Hard code expression for sales = year 2020 ?

[admin11]

Hi All

I have below 2 expression, i though it should be response the same behavious :-

I notice that below expression will be display 2020 year sales amount , even i select year = 2019 :- 

Sales_2020 = CALCULATE([SALES_], DATESYTD(DATEADD('Date'[Date],-1,YEAR)))

I notice that below expression will not display  2020 year sales amount , when i select year = 2019 :- 

Sales_2020_ = CALCULATE([SALES_],FILTER('Date', 'Date'[Year]=2020))

Can some one confirm with me pls.

Paul 

[Ashish_Mathur · Accepted solution]

Hi,

The FILTER() function will pass the baton on to the year chosen in the filter/slicer and disregard the condition specified in the CALCULATE() function.  Therefore the second measure i.e. Sales_2020_ will show the sales of 2019 (if that is what the user selects in the slicer).