Selected month and cumulated in one matrix

[Anonymous]

Hello all, 

I have a matrix I wanted to build where I show the revenue of the actual month (changeable through a filter) and also a column where I show the cumulated revenue of all months. I think that I have to create a measure for hat. 

Customer

Actual Month

Cumulated from the beginning

Thanks! 

[amitchandak · Accepted solution]

@Anonymous , You need a measure like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

[Anonymous]

Hello @amitchandak 

Thank you for the formula. That is what I have add into my dashboard but it somehow shows me random cumulated sales. On the left I have added the formula and in the matrix on the right side I just add all the month into the extra filter. The figures on the right are the correct ones. 

This is the formula I have used: 

Cumulative Total =

CALCULATE(sum(Table_Query_from_DataVirtualityUnicode[Umsatz]),

FILTER(ALL(Table_Query_from_DataVirtualityUnicode),

Table_Query_from_DataVirtualityUnicode[Auftragsdatum] <= MAX(Table_Query_from_DataVirtualityUnicode[Auftragsdatum])))

EDIT: 

I have tested it without the rows for "partner company" and then it seems to work. What could be the reason?