Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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 , 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
Thank you, Amit! This makes sense and I verified with the data. Appreciate your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |