Cumulative Sales - per customer

[GabbyGla]

Hello dear all, 

I got a solution for the gerenal cumulated sales (running total) with following formula which works fine in a matrix where the date is in rows: 

Kumuliert = CALCULATE(sum(Table_Query_from_DataVirtualityUnicode[Umsatz]),filter(all(Table_Query_from_DataVirtualityUnicode),Table_Query_from_DataVirtualityUnicode[Auftragsdatum]<=Max (Table_Query_from_DataVirtualityUnicode[Auftragsdatum])))

 Here the matrix which is fine! 

The problem is that I need to show the sales per customers in a row. So at the end it looks like this: 

Customer A - Sales April - Cumulated Sales 

But when I put the customer in the row section of the matrix visual it gives me kinda confusing figures which are not right. 

Is there anything I need to add in my formula or do I have to create another measure for this case? 

Thanks a lot! 

[johnt75]

Not sure why column totals wouldn't show up, I don't see anything in the code to affect that

[johnt75 · Accepted solution]

Try changing it to

Kumuliert =
CALCULATE (
    SUM ( Table_Query_from_DataVirtualityUnicode[Umsatz] ),
    FILTER (
        ALLEXCEPT ( Table_Query_from_DataVirtualityUnicode, Table_Query_from_DataVirtualityUnicode[Customer Name] ),
        Table_Query_from_DataVirtualityUnicode[Auftragsdatum]
            <= MAX ( Table_Query_from_DataVirtualityUnicode[Auftragsdatum] )
    )
)

I think that should work both with and without the customer in the matrix.

You may need to add more columns into the ALLEXCEPT if there are additional columns in the matrix e.g. customer ID.

[GabbyGla]

Thank you so much! It really worked! Can you tell me why the matrix does not give me the total at the end of each column? 🙂