Forum Discussion
Solle
Helper III
Helper IIICumulative sum on summarize table
Hi All, I have a summarize function from the below code: VAR v1 =
SUMMARIZE(
FILTER(
FactSales,
FactSales[AsOfDate] = CALCULATE(MAX(FactSales[AsOfDate]), ALL(DimDate))
...
SolleHelper III
Helper IIIHi Wilson_ ,
I am actually getting what I want but not just for the subtotals, which was the one I was focussing on, I didnt realize that the subtotal could sum to something different than the above rows.
So I am achieving what I seek but for the totals/subtotals in my table I am getting some very weird values, which does not correspond to the rows above, do you know how to fix this?
| Product Category | Sub Product Category | Cumulative Sales |
| 1 | 1 | 927 |
| 1 | 2 | 7.953 |
| 1 | 3 | |
| 1 | 4 | 245 |
| 1 | 5 | |
| 1 | 6 | 1.216 |
| 1 | Subtotal | 7.953 |
| 2 | Subtotal | 792 |
| 3 | Subtotal | 2.761 |
| Total | 7.953 |
I have attached the results from my matrix where the correct subtotal for product category 1 should be 10.341.
Best Regards,
Solle
Wilson_
Memorable Member
Memorable MemberHey Solle,
I think at this point, it might be easier for me if you could provide your pbix file (or a sanitized/smaller version) so I can look under the hood. 😄