Hierarchy level total

vasathi Something like this:
MEASURE =
SUMX (VALUES('TableName'[Node 3]),  [Closing balance * Average% (Measure)])
It will show in node 3 your measure and will sum up the values for node 2 and aso for node 1.

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI

vasathi please try:

SUMX ( 
	VALUES ( 'TableName'[Node 2] ), 
	CALCULATE(
		SUMX
			VALUES ( 'TableName'[Node 3] )
			[Closing balance * Average% (Measure)] 
	)
)