Count rows where year is .....

Hi Anonymous .

Try this DAX;

annuleringen 2021 = CALCULATE( COUNTROWS(Sheet0), YEAR ( Sheet0[datum verwijsbrief] ) = 2021)).

Regards,
Sanket.

If this post helps , then mark it as 'Accept as Answer' and give it a thumbs up.

Hi Anonymous 

It seems you want to count the non-blank rows in [reden voor annulering] column for every year. You can first add a Year column to the table.

Then create the following measure

Count Measure = CALCULATE(COUNT(Sheet0[reden voor annulering]),Sheet0[reden voor annulering]<>BLANK())

Put Year column and the measure into a table visual, you will get the count for every year. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.