Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

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

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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
Not applicable

@Syndicate_Admin Perfect, thanks!

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

Thank you.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.