Matrix Row level Total Calculation

[Anonymous]

In my sample data B1,B2, B3 is child level of B, so we don't sum them in the total. However I need to show them in the detail.  Please give me some idea 

Project	Code	Amount
101	A	100
101	B	800
101	B1	160
101	B2	320
101	B3	210
102	A	130
102	B	800
102	B1	270
102	B2	260
102	B3	560

Final Result:

[HoangHugo · Accepted solution]

Hi, please try this

measure

SUM = 
var select_code = SELECTEDVALUE (Code column)

return if (select_code <> blank(),SUM(Amount),CALCULATE(SUM(Amount), Code column in {"A","B"}))

[Anonymous]

Thanks a lot, It works for me