MS Excel / VBA help thread

I'm trying to create running totals in power bi.
It's fairly easy to cheat using quick measures.

I have a table with multiple fields. If I want to create a running total for one field it's easy to cheat and use a quick measure:

Sum of running total in Date =
CALCULATE(

SUM('table'[value]),
FILTER(
    ALLSELECTED('table'[Date]),
    ISONORAFTER('table'[Date], MAX('table'[Date]), DESC)
)

Which creates a running total of value based on the date. I can use filters / slicers on the page to filter by the other fields (for example [Location]). But what I want to know is:

How can I create either a measure (dax) or a column in the table (m/powerquery) to create a running total for each location on a date.

So something like

ALLSELECTED('table'[Date]),'table'[Location]),
I would have thought would work but hasn't yet.

I found this: https://www.myonlinetraininghub.com/grouped-running-totals-in-power-query

But I couldn't get it to work on more than two groupings.

But ultimately, what I'd like to do is create running totals for multiple fields (i.e. more than date + location, because there are people of certain ages in the location at certain times).

So I'd like to be able to say: on 08 04 2021 there were a total of 74 men who'd been to place x, while on 09 04 2021 there were 78 men at location x. Make sense?

|Date |Location |Sex |Value|