Forum Discussion

manish_tripathi's avatar
manish_tripathi
Frequent Visitor
4 years ago
Solved

Active users on a given date in a Month

I am working to get cumulative distinct count of uids on daily basis. My dataset consists dates and UserIDs active on that date. Example : Say there are 2 uids (235,2354) appeared on date 2022-01-01 ...
Need Help
Tutorial Requests
  • m_alireza's avatar
    m_alireza
    4 years ago

    Hi manish_tripathi ,

    Try this measure

    Daily_Cumulative_Count = CALCULATE(DISTINCTCOUNT('Table'[User ID]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • manish_tripathi's avatar
    manish_tripathi
    Frequent Visitor
    4 years ago

    Thank you by replacing all with allselected it worked like a charm

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      You are welcome.