Weighted/Rolling Sum based on Attribute

[sgsukumaran]

I am trying to calculate a rolling/weighted sum of revenue. Here is my scenario. I have pivoted Cost by order Number and material number. whenever the Same material is used between orders then it should sum up the cost by material. In this scenario 555+ 900 and so on. The sum should happen only when they have material in common. 

[Anonymous · Accepted solution]

Hello @sgsukumaran,

You need to create a Measure including the functions ISFILTERED and HASONEFILTER

That way you tell to you measure if the Actual $'s is opened in any way to behave in a way, if not to just do the running total.

Below is the Basic Running total, just need to update with your filters.

CALCULATE(
	[Actual $'s];
	FILTER(
		ALLSELECTED(your table[Row Labels]);
		ISONORAFTER(your table[Row Labels]; MAX(your table[Row Labels]); DESC)
	)
)