How to reset running total by a dimension value

We want to create a running total over time for each state and we want it to reset for each state.  If I create a running total quick calc off of an existing measure it totals across all states.  I want to only have the running total for each state.

3 replies

    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Official response
    • Reported - view

    Hi Robert,

    Here you go:

    If this is a Pyramid Semantic Model, you could also consider using the (relatively) new semi-additive Cumulative Aggregation option in the Model. This will then handle all scenarios without you having to code a calculation for it:

    This post should really be  in the Q&A forum.

    Hope that helps.


      • Let me connect you
      • Community_chris
      • 1 yr ago
      • Reported - view

      Ian Macdonald  Moved it to Q&A

    • Robert_Clark
    • 1 yr ago
    • Accepted
    • Reported - view

    Thank you so much Ian Macdonald !!

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 48Views
  • 2 Following