Forum Discussion

manish_tripathi's avatar
manish_tripathi
Frequent Visitor
3 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
    3 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
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

manish_tripathi's avatar
manish_tripathi
Frequent Visitor
3 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
3 years ago

You are welcome.