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 1 1 100 Territory 1 2 50 Territory 1 3 50 Territory 1 4 40 ...
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

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