Forum Discussion
Solved
count the active users
i'm trying to make a mesure that count the active users active user is some one that have more then one activity id (activity id is a uniqe number) i try this: ActiveUsers = CALCULATE(distinctco...
Here's a measure to get number of active users.
ActiveUsers1 =COUNTROWS(FILTER(DISTINCT(FactActivity[UserId]),CALCULATE(countrows(FactActivity)) > 1))If you have a user dimension table joined to the fact you could use that as the filtered table instead. It may be a bit faster.ActiveUsers2 =COUNTROWS(FILTER(Users,CALCULATE(countrows(FactActivity)) > 1))
how can i count returen and new user?