Forum Discussion

hluque's avatar
hluque
Frequent Visitor
8 years ago
Solved

Cumulative total not working

Hello,   I'm facing an issue with my cumulative total that is surely related to the applied filters. I need to calculate the cumulative revenue and expenses by month and by client.   I've used th...
Need Help
  • hluque's avatar
    hluque
    8 years ago

    At the end I figured it out, I needed to use the calendar table. Thus it allows me to filter by any client:

     

    IMS_Revenue acumulado = CALCULATE([IMS_Revenue];filter(ALL(Calendario);Calendario[Date]<=MAX(Calendario[Date])))

    Regards.

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

You'll want to look into using ALLEXCEPT rather than ALL and indicate the field which contains your client names. ALL's going to ignore the filters you set on the clients unless you tell it otherwise