Cumulative value of a measure

[Cado_one]

Hello,

I face an issue with a measure (called PreviewCumul).

This is the context :

The [Preview] is a measure corresponding to the [Realized] column if MONTH([Date]) <= 2, else [Provisional] column

Preview = 
VAR MonthCount = 2
RETURN
IF(
    MAX(Dates[MoisNum]) <= MonthCount,
    SUMX(
        'Table1',
        Table1[Realized]
    ),
    SUMX(
        'Table2',
        Table2[Provisional]
    )
)

My problem then concerns the [PreviewCumul] measure that does the running total of [Preview]

PreviewCumul =
CALCULATE(
	[Preview],
	FILTER(
		CALCULATETABLE(
			SUMMARIZE('Dates', 'Dates'[AnnéeMoisTri], 'Dates'[engDate]),
			ALLSELECTED('Dates')
		),
		ISONORAFTER(
			'Dates'[AnnéeMoisTri], MAX('Dates'[AnnéeMoisTri]), DESC,
			'Dates'[engDate], MAX('Dates'[engDate]), DESC
		)
	)
)

As we can see in the table screenshot above, the problem is that as from month number 3 it sums the values of [provisional] only from the beginning of the year instead of summing [Preview] values.

Does anyone have an idea of a clean way to solve it ?

Thanks in advance.

Best regards,

Cado

[amitchandak · Accepted solution]

@Cado_one , You need to try measure like

calculate(Sumx(Values('Date'[Month Year]), [Preview]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

or

calculate(Sumx(Values('Date'[Month Year]), [Preview]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

[Cado_one]

Hi @amitchandak 

The second one is fine, thanks !

Cado