Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative total

  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....
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago
    Anonymous 
    pls try thsi
    Measure = calculate(sum(Opportunity[Amount]),FILTER(all(Opportunity),Opportunity[closedate]<=max(Opportunity[closedate])))
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    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.

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

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.