Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Optimize a Running Total

Hello community,   I manage the data of an app and would need some help to optimize the classical running total    Sign up count =            CALCULATE (            DISTINCTCOUNT( 'Global table...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Try to change you measure to make the filter on the Global Table [Date]

     

    Sign up =
CALCULATE(
          COUNTROWS( 'Users Info' );
          FILTER( 'Users Info'; 'Users Info'[Sign_up] <= MAX( 'Global Table'[Date] )
           )
)

    Then place the 'Global Table'[Date] on the x-axis should work as expected.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

Try to change you measure to make the filter on the Global Table [Date]

 

Sign up =
CALCULATE(
          COUNTROWS( 'Users Info' );
          FILTER( 'Users Info'; 'Users Info'[Sign_up] <= MAX( 'Global Table'[Date] )
           )
)

Then place the 'Global Table'[Date] on the x-axis should work as expected.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey MFelix,

 

 

Wow... Quite frustrating as I've spent a day scooting the internet to see if I could find someone with the same pattern.... I feel a bit dumb.. 

 

Thanks so much it worked, I have to precise for the people who might encounter the same pattern I had to remove the Bi-directionnal Cross-filtering between the two table (Users Info & Main table). Now it's one way: Users Info -> Main Table.

 

 

Thanks Felix,

L