Forum Discussion

rco123456's avatar
rco123456
Microsoft Employee
5 years ago
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(distinctcount(FactActivity[UserId]),filter(factactivity,count(activityid)>1))

example of the data:

dateuseridactivityid
1/6/2021111
1/6/2021122
1/6/2021255
2/6/2021166
DAX
  • PaulOlding's avatar
    PaulOlding
    5 years ago

    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
    )
    )

2 Replies

  • PaulOlding's avatar
    PaulOlding
    Solution Sage
    5 years ago

    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
    )
    )