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. Also will cumulative totals work with slicers? 

 

Thanks! 

 

 

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    There is another column "Close Date" 

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      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
    Community 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.