Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not 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!