running total in Power BI for several groups

[teo9578]

Hi all.

I'm trying to make running total in Power BI like chart below.

It has date and different group name and I want to make running total for each groups.

I used 'quick measure' but it doesn't work.

Could you help me to solve this problem?

[moizsherwani · Accepted solution]

Hi @teo9578 See if this will work for you. I attached the file as an example too

RunningTotal =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Group] ),
        'Table'[Date] <= MAX ( 'Table'[Date] )
    )
)