Solved: Running Total by Index and category

Anonymous · ‎05-19-2022

Hi,

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

Thank you. 🙂

johnt75 · ‎05-19-2022

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

View solution in original post

johnt75 · ‎05-19-2022

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