Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count measure for specific years

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!

Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    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)
)

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    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)
)
      • Syndicate_Admin's avatar
        Syndicate_Admin
        Administrator
        4 years ago

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

        Thank you.