cumulative sub with filter in matrix

[Stefano_0]

Good morning, I have a problem with a matrix.

In this matrix there is the value of the price for month

Month Price

01        10   

02         20

03         20

04         50

05         50

I have also a matrix with the cumulative sum but if i use a filter for the month and I select the month 03 04 05 the value for the month 03 is the sum from month 01 to 03.

Month Price

03         50

04        100

05        100

Is possible exclude the month's not selected?

[Anonymous]

Hi @Stefano_0 ,

You will need ALLSELECTED() function in the formula.

Measure = CALCULATE(SUM('Table'[Price]),FILTER(ALLSELECTED('Table'[Month]),'Table'[Month]<=MAX('Table'[Month])))

Best Regards,

Jay

[Stefano_0]

I have set the month date with a new column

MonthDate = FORMAT(ABZ_VJS01_DOCUMENTI_ORD_CONS[DATE], "MM")

Total Price =

CALCULATE (

SUM ( ABZ_VJS01_DOCUMENTI_ORD_CONS[Price] ),

FILTER ( ALLSELECTED ( ABZ_VJS01_DOCUMENTI_ORD_CONS[MonthDate] ), ABZ_VJS01_DOCUMENTI_ORD_CONS[MonthDate] <= MAX ( ABZ_VJS01_DOCUMENTI_ORD_CONS[MonthDate] ) )

)

The result is a table without sum:

Month Price

03         20

04         50

05         50

[Jihwan_Kim · Accepted solution]

Price Total Cumulate : =
CALCULATE (
SUM ( Data[Price] ),
FILTER ( ALLSELECTED ( Months ), Months[Month] <= MAX ( Months[Month] ) )
)

https://www.dropbox.com/s/164lhkihvp8tw3b/stefano.pbix?dl=0 

[Stefano_0]

perfect, everything works thanks !!!