Aggregating data across rows

[mahoneypat]

I looked at your pbix.  It is similar but different from the pics you show.  I wasn't able to match what you are showing, so it is hard to troubleshoot it.  Also, there are so many columns.  You definitely should unpivot these data and simplify your model to make your analysis/visualization easier.

Regards,

Pat

[littlemojopuppy]

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])
	)
)

[littlemojopuppy]

@Anonymous so in place of the SUM([Value]) insert the name of the measure

[Anonymous]

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.