Cumulative total

[Anonymous]

Hi I am trying to calculate a cumulative total for this column, The table is called opportunities. 

I have tried the quick measure and other solutions for similar posts but It wont work. Also will cumulative totals work with slicers? 

Thanks! 

[ryan_mayu · Accepted solution]

@Anonymous 

pls try thsi

Measure = calculate(sum(Opportunity[Amount]),FILTER(all(Opportunity),Opportunity[closedate]<=max(Opportunity[closedate])))

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to create a measure like this:

Cumulative total =
CALCULATE (
    SUM ( 'Opportunity'[Amount] ),
    FILTER (
        ALLSELECTED ( 'Opportunity' ),
        'Opportunity'[closedate] <= MAX ( 'Opportunity'[closedate] )
    )
)

result:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

There is another column "Close Date" 

[ryan_mayu · Accepted solution]

@Anonymous 

pls try thsi

Measure = calculate(sum(Opportunity[Amount]),FILTER(all(Opportunity),Opportunity[closedate]<=max(Opportunity[closedate])))