Forum Discussion
Solution SageCount per user per day in table
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
rpinxt , Create a calculated column using
DAX
RowCount =
CALCULATE(
COUNTROWS('UserData'),
ALLEXCEPT('UserData', 'UserData'[User], 'UserData'[Day])
)
2 Replies
- bhanu_gautam
Super User
rpinxt , Create a calculated column using
DAX
RowCount =
CALCULATE(
COUNTROWS('UserData'),
ALLEXCEPT('UserData', 'UserData'[User], 'UserData'[Day])
)
rpinxtThanks 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.