Filter year in a calculate function

[amalrio]

Hi Gurus, 

I want to filter Year from a measure using CALCULATE function. 

below is the measure I want, it work fine without Year >= "2021" how could I work this one

Measure = 

VAR Result = CALCULATE(

SUM('FACT-Data'[NUMARIC]),

'DIM-Matrics'[MATRIX_ID] = 14,

'Date'[Year] >= "2021"

)

RETURN

Result

[themistoklis]

@amalrio 

Try the following formula:

Measure = CALCULATE(SUM('FACT-Data'[NUMARIC]),FILTER('DIM-Matrics','DIM-Matrics'[MATRIX_ID] = 14),FILTER('Date','Date'[Year] >= "2021"))

[amalrio]

thanks a lot for the reply. It did not work for me.

my requirement was to return blank when the data for that year is blank. Manged to get it done with a simple IF statment :).

Thanks a lot

[Tahreem24 · Accepted solution]

@amalrio ,

What is the data format of Date[Year]? If you have any Date column with proper format date like YYYY-MM-DD or any other format so try below DAX:

Measure =

VAR Result = CALCULATE(

SUM('Table'[Sales]),

'Table'[ID] = 14,

YEAR('Table'[Date]) >= 2020

)

RETURN

Result