Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Aggregating data across rows

littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

You want to follow the running total DAX pattern.  Your measure should look something like this...

CALCULATE(
	SUM([Value]),
	FILTER(
		ALL(Calendar],
		Calendar[Date] <= MAX(Calendar[Date])
	)
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi littlemojopuppy , 

Thanks for the reply. As you can see in my shared link to pbix file, the value shown are calculated using measure. The name of the measure is "sales ltm". So because of this I'm not able to use SUM() function as it does not take measure value.