Forum Discussion
frequency table or histogram from record level data file
Hi cawalawan
From the screenshot , you can see the difference . When you count the date row with the format ‘Table’[Date].[Year] , the value returned is the sum of all days of the year in your date . So when you count the date rows in desktop , the [unit] following the date does not need to be added .
You can also get a better understanding of COUNT() through the following links .
https://docs.microsoft.com/en-us/dax/count-function-dax
https://inblog.in/Different-Types-of-Count-Functions-in-DAX-5bngj3TVme
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi cawalawan
From the screenshot , you can see the difference . When you count the date row with the format ‘Table’[Date].[Year] , the value returned is the sum of all days of the year in your date . So when you count the date rows in desktop , the [unit] following the date does not need to be added .
You can also get a better understanding of COUNT() through the following links .
https://docs.microsoft.com/en-us/dax/count-function-dax
https://inblog.in/Different-Types-of-Count-Functions-in-DAX-5bngj3TVme
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.