Summarize Running Total that resets as categories changes

[MarioDias]

I am trying to write a SUMMARIZE function that calculates Running Total based on a determined category:

Table

Category 1	Category 2	Total	Running Total (goal)
Apple	Basket 1	5	5
Apple	Basket 2	10	15
Orange	Basket 3	20	20
Apple	Basket 4	20	20
Apple	Basket 5	5	25

I can solve this using DAX + Table visual, because it resets per Category 1:

Running Total =

CALCULATE(

    SUM(Table[Total),

    FILTER(

        ALLSELECTED(Table[Category 2]),

        ISONORAFTER('Table'[Category 2], MAX('Table'[Category 2]), DESC)

    )

)

But I cannot get the same result when using SUMMARIZE as it will just repeat the totals instead of cumulating them accordingly. I need to have it in summarize to apply further filtering for another measure.

Anyone please, any idea?

Thank you!

[MarioDias · Accepted solution]

Hello  everyone.

It looks like switching ALLSELECT by ALLEXCEPT solves the problem. Thanks @parry2k for all the messages.

[parry2k]

@MarioDias still not sure what you are looking for? Maybe if you provide data with the expected results, it will help.

[parry2k]

@MarioDias what is your end goal? Why do you need to summarize? Can you provide more details?

[MarioDias]

Thanks for your message @parry2k 
I will used SUMMARIZE to filter rows and get a scalar value. Filters like showing categories with less than specifict totals.