Count where date greater than

[Anonymous]

Hi, 

How do I create a new measure to say the following please?

mort_no_gtr_2017 = Count (mort_no) where year(mort_date) > 2017 

[StefanoGrimaldi · Accepted solution]

hey try this: 

dates greater tham year 2021 = CALCULATE(COUNT('calendar'[Date]),YEAR('calendar'[Date])>2021) 

you adjust the dax to your exact case, this type of cpunt you want its done with calculate, calculate + sum,average,count etc works as sumif, countif, averageif etc