cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Community Support

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.
Community Support

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.