Forum Discussion

beaoliv123-_'s avatar
beaoliv123-_
Helper I
4 years ago

Lost Users

Hi,

 

I am calculating the lost users using the following formula:

 

Lost Users =
CALCULATE(
DISTINCTCOUNT(table[user_id] ), DATESBETWEEN('Slicer'[Date], MIN('For Slicer'[Date])-365, min('Slicer'[Date])-90),
FILTER(
SELECTCOLUMNS(
FILTER( ALL( table)table[date] < MIN('For Slicer'[Date])),
"@user_id", table[user_id]
),
NOT [@user_id] IN VALUES( table[user_id])
),
ALL()
)

 

And the output is this:

What is happening is that this is cumulative and I just wanted to know how many users were lost each day, instead of a specific day to the past.

 

Do you know how do a fix this?

 

Thanks

Need Help