Running Total - 2 categories

[EckbertO]

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

[v-qiuyu-msft · Accepted solution]

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