Forum Discussion
Helper IIHierarchy 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.
Community Championvasathi 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.
Helper IIDear
as per the calculation the 2nd level total showing correctly and 1 level not summingup correctly
Could you help me ....
- SpartaBI
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 🙂