Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
can provide you the exact solution if get a snapshot of data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |