How do I keep the amount accumulated when the day is zero?

[tiagomarciano]

How do I keep the amount accumulated when the day is zero?

[tiagomarciano · Accepted solution]

I solved with this code. Tks!

Total acumulado de Funel Inscritos 2016 em Dia = 
CALCULATE(
	'Métricas de Negócio'[Funel Inscritos 2016];
	FILTER(
		ALLSELECTED('DIMdia'[Dia]);
		ISONORAFTER('DIMdia'[Dia]; MAX('DIMdia'[Dia]); DESC)
	)
)

[Vvelarde · Accepted solution]

@tiagomarciano

Hi, you ca obtain with a Quick Measure - Running Total

Inscritos running total in Date =
CALCULATE(
SUM('Table1'[Inscritos]),
FILTER(
ALLSELECTED('Table1'[Date]),
ISONORAFTER('Table1'[Date], MAX('Table1'[Date]), DESC)
)
)

Regards

Victor

Lima - Peru

[tiagomarciano · Accepted solution]

I solved with this code. Tks!

Total acumulado de Funel Inscritos 2016 em Dia = 
CALCULATE(
	'Métricas de Negócio'[Funel Inscritos 2016];
	FILTER(
		ALLSELECTED('DIMdia'[Dia]);
		ISONORAFTER('DIMdia'[Dia]; MAX('DIMdia'[Dia]); DESC)
	)
)