Forum Discussion
Count and distinct count pulling in the same value
Hi everyone,
I'm trying to visualize total and distinct users by day and week. By week seems to be pulling in ok, but the by day counts are the same for some reason, and I can't figure out how to fix it. Both visuals and table attached have the same measures pulled in;
Total Users = COUNT (GA[UserID])
Unique Users = DISTINCTCOUNT (GA[UserID])
Thanks!
Anonymous , seem like in this case for each date userID record is there only one time in the table. that is why it is same at day level, as subtotal will recalculated for distinct count , you are getting a different number in subtotal
2 Replies
Anonymous , seem like in this case for each date userID record is there only one time in the table. that is why it is same at day level, as subtotal will recalculated for distinct count , you are getting a different number in subtotal