Forum Discussion

vasathi's avatar
vasathi
Helper II
4 years ago
Solved

Hierarchy level total

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 * Aver...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
    SpartaBI
    4 years ago

    vasathi please try:

    SUMX ( 
	VALUES ( 'TableName'[Node 2] ), 
	CALCULATE(
		SUMX
			VALUES ( 'TableName'[Node 3] )
			[Closing balance * Average% (Measure)] 
	)
)
vasathi's avatar
vasathi
Helper II
4 years ago

You are a great and helped me lot.

thanks again