Forum Discussion
Daily distinct count on snapshots table
Hello,
I have daily snapshots table with snapshot_date, user_id and last_activity_at fields. The pair of user_id and last_activity_at is not unique, due to a number of snapshots can contain the same user_id and last_activity_at. I want to build just a line chart visual with distinct count of users through days. I have the dates table for the X axis, how to create the Y axis measure? Sounds like not something complicated, but I'm new in Power BI, please help.
Thanks.
Hi IgorChe ,
Please try to create a measure with below dax formula:
Distinct User Count = DISTINCTCOUNT('YourSnapshotTableName'[user_id])Replace 'YourSnapshotTableName' with the actual name of your daily snapshots table.
Drag your date field from the dates table to the Axis area of the line chart. Then, drag the Distinct User Count measure you just created to the Values area.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi IgorChe ,
Please try to create a measure with below dax formula:
Distinct User Count = DISTINCTCOUNT('YourSnapshotTableName'[user_id])Replace 'YourSnapshotTableName' with the actual name of your daily snapshots table.
Drag your date field from the dates table to the Axis area of the line chart. Then, drag the Distinct User Count measure you just created to the Values area.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you, v-binbinyu-msft
It's a right answer, I already tried it, but had wrong result because a relationship was broken. I fixed it and everything looks good now.
Thank you!
