cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## How to calculate Sum of Daily Active Users?

Hey guys,

quick DAX question. I have two tables, one table with users (two columns: users[id], users[name]) and another table with actions (actions[date], actions[user_id]). Besides that I have a calendar table.

Now I want to calculate the number of "active users", meaning the number of users who are active per time frame. That's pretty easy via:

```Active Users =
CALCULATE(
COUNTROWS(users),
FILTER(users,
CALCULATE(
COUNTROWS(actions),
FILTER(ALL(actions),
actions[user_id] = users[id] &&
actions[date] >= MIN(calendar[Date]) &&
actions[date] <= MAX(calendar[Date])
)
) > 0
)
)```

But if I want to calculate the number of "Daily Active Users" per time frame, meaning the Sum over the number of days one user is active per time frame over all users, I don't have any clue how to do that in a measure without creating an extra Crossjoin table between the users table and the calendar.

Any clues?

Thank you,

Sebastian

1 ACCEPTED SOLUTION
Community Champion

Daily active = SUMX(Calenders,Calenders[Active Users])

I have kept your original measure as it is and created a iteration over the calender table which will give you the desired result.

Sum of Daily active users.

Hope this will solve your problem.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
3 REPLIES 3
Community Champion

Daily active = SUMX(Calenders,Calenders[Active Users])

I have kept your original measure as it is and created a iteration over the calender table which will give you the desired result.

Sum of Daily active users.

Hope this will solve your problem.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Community Champion

can provide you the exact solution if get a snapshot of data.

Thanks & Regards,
Bhavesh

Love the Self Service BI.

@BhaveshPatel Sure. I created a test sample. Here you go

Test.pbix

Thank you!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.