Hierarchy level total

[vasathi]

Team

i have problem in allocations in Hierarchy reports in Matrix.

Lets say i have 3 level (Age Summary / Age Group / Category) in my report

The 3 Node calclation is Closing balance * Average% 
i need a calculations
        in 2nd Node is sum of 3 node
        in 1st Node is sum of 2 Node

i don't know clue how to proceed for this calculation

Download Samples 

[SpartaBI · Accepted solution]

@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.

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

@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.

      

Showcase Report – Contoso By SpartaBI

[vasathi]

Dear 

as per the calculation the 2nd level total showing correctly  and 1 level not summingup correctly

Could you help me ....

[SpartaBI · Accepted solution]

@vasathi please try:

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

[vasathi]

You are a great and helped me lot.

thanks again

[SpartaBI]

@vasathi my pleasure my friend.
Will really appreciate your Kudos on my messages 🙂
P.S.
Check out my showcase report - got some high level stuff there.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over ther if you liked it 🙂