Count and distinct count pulling in the same value

[Anonymous]

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!

[amitchandak · Accepted solution]

@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

[Anonymous]

Thank you, Amit! This makes sense and I verified with the data. Appreciate your help!