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.