Forum Discussion

Isildur13's avatar
Isildur13
Frequent Visitor
3 years ago
Solved

Count number of active users

Hi all I need help with creating either a DAX or PQ calculations that can give me the number of registered users. The issue is that a user can be registered multiple times before the system recog...
Tips and Tricks
  • gmsamborn's avatar
    gmsamborn
    3 years ago

    Hi Isildur13 

     

    Maybe try this measure.

     

    zMeasure = 
VAR _Table1 =
    SUMMARIZE(
        'Date',
        'Date'[Month],
        "Users",
            DISTINCTCOUNT( 'Table1'[UserID] )
    )
VAR _Result = 
    SUMX(
        _Table1,
        [Users]
    )
RETURN
    _Result

     

     

    Also, based on your description and your expected results, this sounds more like "New users by month" instead of "active users"  as you stated in the title of your thread. 

     

    Please let me know if I've misunderstood anything.

     

    Count of NEW users.pbix

  • gmsamborn's avatar
    gmsamborn
    3 years ago

    Hi Isildur13 

     

    Offhand, I can think of an easy way to do that.

     

    The "best" way I can I think of would be to incorporate this period into your date table.  It could be calculated based on a day-offset column if your date table has that.  (If not, I reccommend it.)

     

    I hope this make sense.  Let me know if you want an example of a date table with offset columns.

Isildur13's avatar
Isildur13
Frequent Visitor
3 years ago

Hi gmsamborn 

 

It worked and I added the Year as a column as well 🙂

 

One follow up question - would it also be possible if I instead would use a rolling 40 day instead of the month?

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
3 years ago

Hi Isildur13 

 

Offhand, I can think of an easy way to do that.

 

The "best" way I can I think of would be to incorporate this period into your date table.  It could be calculated based on a day-offset column if your date table has that.  (If not, I reccommend it.)

 

I hope this make sense.  Let me know if you want an example of a date table with offset columns.