Forum Discussion
rpinxt
Solution Sage
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 ...
rpinxt , Create a calculated column using
DAX
RowCount =
CALCULATE(
COUNTROWS('UserData'),
ALLEXCEPT('UserData', 'UserData'[User], 'UserData'[Day])
)
bhanu_gautam
Super User
Super Userrpinxt , 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.