topic Re: count the active users in DAX Commands and Tips

count the active users

rco123456 — Thu, 01 Jul 2021 16:20:23 GMT

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:

PaulOlding — Thu, 01 Jul 2021 16:47:01 GMT

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

)

rco123456 — Thu, 01 Jul 2021 17:45:48 GMT

how can i count returen and new user?