Count per user per day in table

[rpinxt]

This is a (very) simplified table:

User	Day	Count
A	1	2
B	1	1
A	1	2
D	1	2
D	1	2
A	2	2
B	2	2
C	2	1
D	2	1
A	2	2
B	2	2
C	3	2
D	3	2
C	3	2
D	3	2
A	4	1
D	4	1

I want to make a calculated column for the values here in colum 'Count'

So there are much more columns but column User and Day are the columns in scope.

I want to count the number of rows by user by day (which will be a date field).

Kind of making subtotals by user and day

[bhanu_gautam · Accepted solution]

@rpinxt , Create a calculated column using

DAX
RowCount =
CALCULATE(
COUNTROWS('UserData'),
ALLEXCEPT('UserData', 'UserData'[User], 'UserData'[Day])
)

[rpinxt]

Thanks @bhanu_gautam this is doing what I want, but I am a bit confused why it is working 😄

I do not understand the ALLEXCEPT because I would expect that you just would want these 2 fields and not the rest.

This feels like the other way around.