cumulative count day over day/week over week/Month over month

[Anonymous]

Hi,

Attached a sample pbix.

https://drive.google.com/file/d/1ripLoGNkbKOZvUf3oZtgtEBMNafQF7jP/view?usp=sharing

I would like to have cumulative count of users who are inactive each day  or end of each week or end of month.I tried the below but it doesnt give me the output and query times out.Pls help.Attached is the sample data and expected output.

Note: Last_accessed is related to Date (active). Snaphotdate and Date are related as inactive.

My meaure:

CALCULATE (

COUNTROWS( Dim ),Dim[Activity]="Inactive",USERELATIONSHIP ( Date[Date], Dim[SnapshotDate] ),FILTER(allselected(Date),Date[Date]<max(Dim[snapshotdate])))

This measure correct running counts by Day as you see below:

The issue is i am not able to all inactive see users data when i bring in username column into column chart.It just gives me 3 users instead of 59 users name(because it only picks ones from active relationship not from inactive) ,can you please point out how to fix this.:

I want see the output in my visual like one highlighted :