Average of a measure

[frg88]

Hi, 

In the next visual I've made an average of the number of cases by user registration year, similar to we can see in this post: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Count-open-ticket-in-first-7-days-after-the-u... 

Now, in the signUp table I have too the unsuscribe user date:

CustomerId	SignUp	Unsuscribe
1	2021-01-01	2021-03-01
2	2021-02-01	2021-03-01
3	2021-03-01	2021-03-01

What I want is that the average of the previous visual only takes the sum of active users by day, by example, if I have 2 active users today, the measure must divide the number of cases by 2 users.

Is that possible?

Thanks!

[amitchandak]

@frg88 , refer to my blog to get the active user(current employee) on a day/ month or year

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...