Attendance or count based on 2 fields

Hi rains_23 

When using the count of “Login Date” in the matrix, the total is 10, isn't that what you want? May I ask what you expect the total to be?

If I use the count of (Login date) in a matrix it gives correct, but the total does not come as correct.

Here is my test result:

Create new columns with the following DAX:

MonthYear = FORMAT([Login Date], "YYYY-MM")

WeekNumber = WEEKNUM([Login Date])

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.