count the active users

[rco123456]

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(distinctcount(FactActivity[UserId]),filter(factactivity,count(activityid)>1))

example of the data:

date	userid	activityid
1/6/2021	1	11
1/6/2021	1	22
1/6/2021	2	55
2/6/2021	1	66

[rco123456]

how can i count returen and new user?

[PaulOlding · Accepted solution]

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

)

)