Forum Discussion

IgorChe's avatar
IgorChe
Frequent Visitor
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • IgorChe's avatar
    IgorChe
    Frequent Visitor
    2 years ago

    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!