Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Active userbase calculation

Hi Community Members,   Have been wrapping my brain around this one, but can't seem to figure this one out on my one. I have a basic flat table with login behavior. A timestamp of login and which u...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    I created sample pbix file, you can get it from this link.

    Best Regards

    Rena

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Please try this expression for the count of users that were active in all of the previous four weeks.

 

Active Users =
VAR __thisweek =
    MIN ( 'Date'[WeekNumber] )
VAR __summary =
    FILTER (
        CALCULATETABLE (
            ADDCOLUMNS (
                SUMMARIZE ( Login, 'Date'[WeekNumber], Login[user_id] ),
                "@logins", CALCULATE ( COUNTROWS ( Login ) ) + 0
            ),
            ALL ( 'Date'[WeekNumber] ),
            'Date'[WeekNumber] < __thisweek
                && 'Date'[WeekNumber] >= __thisweek - 4
        ),
        [@logins] > 0
    )
VAR __usersummary =
    FILTER (
        SUMMARIZE ( __summary, Login[user_id], "@weeks", COUNTROWS ( __summary ) ),
        [@weeks] = 4
    )
RETURN
    COUNTROWS ( __usersummary )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat