cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Running Total - 2 categories

Hi,

I'm new at PowerBI and DAX and struggling generating a cumulative total on the following table:

 Territory 1 1 100 Territory 1 2 50 Territory 1 3 50 Territory 1 4 40 Territory2 1 100 Territory2 2 50 Territory2 3 50 Territory2 4 40

Table header are : Territory / Quarter / Sales

The cumulative should run per quater for each territory.

Can someone help ?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: Running Total - 2 categories

Hi @EckbertO,

You can create a measure below,

`Measure = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),'Table1'[Quarter]<=MAX(Table1[Quarter]) && 'Table1'[Territory]=MAX(Table1[Territory])))`

Also you can create a calculated column,

`runningtotal = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),'Table1'[Quarter]<=EARLIER(Table1[Quarter]) && 'Table1'[Territory]=EARLIER(Table1[Territory])))`

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support

## Re: Running Total - 2 categories

Hi @EckbertO,

You can create a measure below,

`Measure = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),'Table1'[Quarter]<=MAX(Table1[Quarter]) && 'Table1'[Territory]=MAX(Table1[Territory])))`

Also you can create a calculated column,

`runningtotal = CALCULATE(SUM(Table1[Sales]),FILTER(ALL(Table1),'Table1'[Quarter]<=EARLIER(Table1[Quarter]) && 'Table1'[Territory]=EARLIER(Table1[Territory])))`

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (774)