Multiple category cumulative sum

[Kanyi]

Hi please assist. I have been struggling with the below, any help will be apreciated. I want to calculate a cumulative sum of the metres based on site and discipline. The running total and creating an index column does not work as it does not stop and start afresh when a new discpline is encountered or a new site and discipline start.

Data

Desired output

[bhanu_gautam · Accepted solution]

@Kanyi , Create a calculated column using below DAX

CumulativeSum =
CALCULATE(
SUM(Table[Metres]),
FILTER(
ALLEXCEPT(Table, Table[Site], Table[Discipline]),
Table[Date] <= EARLIER(Table[Date])
)
)