Forum Discussion
Solved
Running Total
I am trying to calculate a running total for a production line based on the Machine name, there is no date value. I am using a Direct Query to SQL database. I want to add an exta column for running...
Eyy, I think I got it. Try this:
RunningTotal2 = MAXX(Table1, SUMX( FILTER( SUMMARIZE(CALCULATETABLE(Table1, ALLEXCEPT(Table1, Table1[Building]), ALLSELECTED(Table1[Building])), Table1[MachineName], "NetVal", SUM(Table1[Fabrication Net Value])), [NetVal] >= SUMX(FILTER(CALCULATETABLE(Table1, ALLEXCEPT(Table1, Table1[Building]), ALLSELECTED(Table1[Building])), Table1[MachineName]= EARLIER(Table1[MachineName], 2)), Table1[Fabrication Net Value])) , [NetVal]))
Hopefully you can see how that would scale out to other columns if you had multiple filters.
Did you try the measure I included earlier, and if so what was the result?
Here is the measure I used and the results:
RunningTotal = MAXX(vwScalesDataFabricationNetValue, CALCULATE(SUM(vwScalesDataFabricationNetValue[Fabrication Net Value]), vwScalesDataFabricationNetValue[Fabrication Net Value] >= EARLIER(vwScalesDataFabricationNetValue[Fabrication Net Value]), ALL(vwScalesDataFabricationNetValue)))
| Ranking | MachineName | Fabrication Net Value | RunningTotal |
| 1 | Quarrata | 21003 | 74934 |
| 2 | Rollpacks | 16752 | 87249 |
| 3 | Tightwinder | 12390 | 78010 |
| 4 | T8 ( 2 ) | 10217 | 87114 |
| 5 | T8 ( 4 ) | 5821 | 88776 |
| 6 | Cut off saw | 5801 | 89000 |
| 7 | OEM VCC's | 5133 | 88822 |
| 8 | T8 ( 3 ) | 2509 | 85088 |
| 9 | T8 (1 ) | 2155 | 76690 |
| 10 | Tarp saw | 1906 | 88949 |
| 11 | Mattress | 1435 | 79222 |
| 12 | OEM CNC | 1126 | 89020 |
| 13 | T8 ( 5 ) | 889 | 88625 |
| 14 | Fillmatic | 724 | 35792 |
| 15 | Quality Samples | 497 | 85254 |
| 16 | C52 Pillow Machine | 309 | 88977 |
| 17 | Bun Roller Machine | 229 | 62330 |
| 18 | Chinese Carousel | 124 | 78134 |