Count measure for specific years

[Anonymous]

Hi,

I want to count all the days in my data for the year 2019. How can I filter to only those days with a measure?

I came up with something like this: Measure = COUNTAX(FILTER(Date_Table, Date.Year = 2019)), but thats not working!

[Syndicate_Admin · Accepted solution]

Good afternoon dear.

Do you want to count the amount of data that has a date in the year 2019?

If so, I advise you this DAX

CountRows = 
COUNTROWS (
    FILTER ( 'Table', 'Table'[Column1].[ Year] = 2019)
)

[Anonymous]

@Syndicate_Admin Perfect, thanks!

[Syndicate_Admin]

Please accept it as a solution so that other people who have the same question can find it faster.

Thank you.