Forum Discussion

EckbertO's avatar
EckbertO
Regular Visitor
8 years ago
Solved

Running Total - 2 categories

Hi, 

 

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

 

Territory 11100
Territory 1250
Territory 1350
Territory 1440
Territory21100
Territory2250
Territory2350
Territory2440

 

Table header are : Territory / Quarter / Sales

 

The cumulative should run per quater for each territory. 

 

Can someone help ?

 

Thanks

Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    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