Forum Discussion

DouglasRoubaud's avatar
DouglasRoubaud
Frequent Visitor
4 years ago
Solved

Acumulated Sum

Dear,
As in the example below, I show an accomplished vs. meta... but by my measure, the "total" is just marking the last day of the selected period.

 

I would like to do a sum of this accumulated, which would give a total result of 244,484.

What I need it´s, the sum of my accumulated.

 

The formula that I´m using is this:
 

 

I put the "all" on the week because I have a filter for the weeks that I want to select, with this all, it makes the right accumulated for that day. Just for that.
 
Thanks.
 
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    DouglasRoubaud , You can try a measure like

     

    Cumm Real= CALCULATE(SUM(Table[Real]),filter(allselected('Table'),'Table'[CO_tempo] <=max('Table'[CO_tempo])))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    DouglasRoubaud , You can try a measure like

     

    Cumm Real= CALCULATE(SUM(Table[Real]),filter(allselected('Table'),'Table'[CO_tempo] <=max('Table'[CO_tempo])))