Running Total by Index and category

[Anonymous]

Hi,

Can you help me make the running total like the example in the excel below but as a DAX calculation?

Thank you. 🙂

[johnt75 · Accepted solution]

Running Total = 
var currentEvent = SELECTEDVALUE('Table'[Event number])
return CALCULATE( SUM('Table'[Quantity]),
ALLEXCEPT('Table'[Case]),
'Table'[Event number] <= currentEvent
)