Forum Discussion

Solle's avatar
Solle
Icon for Helper III rankHelper III
3 years ago

Cumulative 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)) ...
cumulative
DAX
SUMMARIZE
Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Solle,

 

Can you help clarify your request? If you want one cumulative total amount that ignores the date slicer, are you not just looking for total sales? If that's not what you're looking for, what number are you expecting this measure to return, based on the results of the original post's table? 

Solle's avatar
Solle
Icon for Helper III rankHelper III
3 years ago

Hi 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 CategorySub Product CategoryCumulative Sales
11927
127.953
13 
14245
15 
161.216
1Subtotal7.953
2Subtotal792
3Subtotal2.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_'s avatar
    Wilson_
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hey 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. 😄