Sheet Filter/Slicer & Running total issue

[Anonymous]

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

[v-chuncz-msft]

@Anonymous,

Try to remove [Jour] from the formula above.

[Anonymous]

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!

[Anonymous]

up =D Please tell me if I need to somehow precise my need... I really need to get that working