Forum Discussion
Sheet Filter/Slicer & Running total issue
Hey community,
So, I'm trying to create a running total function for the amount of users we have on our app.
Originally I have a table with actions performed by users (like send message, log in log out.....).
I created a new table with unique list of emails, sign up date & active days to make it easier:
Users Info = SUMMARIZE( 'Global table', 'Global table'[email],
"Sign_up", MIN('Global table'[date].[Date]),
"Active_days", DISTINCTCOUNT('Global table'[date].[Jour]))
From that table I created a running total formula such as:
Sign up =
CALCULATE (
COUNT( 'Users Info'[email] ),
FILTER ( ALLSELECTED('Users Info'),
'Users Info'[Sign_up].[Jour] <= MAX ( 'Global table'[date].[Jour] )
)
)
I do get the right curve but the sheet filters are simply not applying to it. The curve is static from first date to last date and takes all users.
I would like to be able to filter date & companies as I do with all of my other graphs. Do you guys have a clue of why filters are not working ?
Thanks in advance,
Leonard
3 Replies
- AnonymousNot applicable
up =D Please tell me if I need to somehow precise my need... I really need to get that working
- v-chuncz-msft
Community Support
Anonymous,
Try to remove [Jour] from the formula above.
- AnonymousNot applicable
Well it did something, the date filter is now working!
Thanks v-chuncz-msft
The domain filter (I use email domain to filter companies) is yet still not working :(
I am getting a portion of the total graph for date selected with all app users!