Forum Discussion
Active userbase calculation
Hi Anonymous ,
You can create a measure as below:
Active userbase =
CALCULATE (
DISTINCTCOUNT ( 'Userbase'[user_id] ),
FILTER (
'Userbase',
WEEKNUM ( 'Userbase'[timestamp] )
>= SELECTEDVALUE ( 'DATE'[Weeknumber], WEEKNUM ( TODAY () ) ) - 4
&& WEEKNUM ( 'Userbase'[timestamp] )
< SELECTEDVALUE ( 'DATE'[Weeknumber], WEEKNUM ( TODAY () ) )
)
)Best Regards
Rena
Hi Anonymous,
Out of all possible solutions, your solution gives me back some data. However, I do have two comments:
1. What happens when we move into the new year. Does the calculation still hold for week 2 of 2021, where I would like to see data for week 50 - 52 [2020] and week 1 of 2021?
2. When I make a card. It gives me back the number I am expecting. However, When I add weeknumber on the x-axis and I wish to see the trend per week, it simply gives me back the user count of that week. What I was expecting is that it would give back the distinct user count of the four weeks before week 26 [week 22 - 25]. And when I look at the week before that week 25 [week 21 - 25]. This is not what is happening. Any idea what might be happening?