Measure calculate function with few filters

Hi IlyaF ,

If you want to filter by the current year then you will have to surround the column (Timestamp Entered State) by year function so the updated measure will be like:

Abandoned_new = calculate(
count(
'Apps & Grants'[Grant ID]),
('Apps & Grants'[Current State]="Abandoned"||
'Apps & Grants'[Current State]="Withdrawn" ||
'Apps & Grants'[Current State]="Declined" ||
'Apps & Grants'[Current State]="To Delete"),

Year('Apps & Grants'[Timestamp Entered State])= YEAR(TODAY())

)

 Hope this helps 

Thanks,

AnthonyJoseph