Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to 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)
)
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)
)
Please accept it as a solution so that other people who have the same question can find it faster.
Thank you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
104 | |
65 | |
64 |