Parent / Child Relation + Multiply

[mg]

Hi !

Ive the following table. 

Ive succeeded with Power BI to sum for A (=B+F) and B(=C+D+E) through a parent / child relationship. 

Nevertheless, i wd like to add a mark-up on A and B meaning B = (C+D+E)*1,07 and A =(B+F)*1,07. 

Any suggestion would be highly appreciated 🙂

Many thanks 

ITEM	PathID	Level of Current Element	Type	Current Element	Current Element Issue Index	Parent Element	Parent Type	Parent Issue Index	Quantity (link only)	Designation	Unit Price
A	D57248000004	0	DASSY	D57248000004	AS	NULL	DASSY	NULL	NULL	WING BOX STRUCTURE GA
B	D57248000004 / D57248006010	1	DASSY	D57248006010	M	D57248000004	DASSY	AS	1.0000000	BOLTING PNL 1 FS BTM
C	D57248000004 / D57248006010 / ABS0548VHK4-06	2	STDPT	ABS0548VHK4-06	NULL	D57248006010	DASSY	M	25.0000000	PIN,SWAGELOCKINGCSK	50
D	D57248000004 / D57248006010 / ASNA2025-4	2	STDPT	ASNA2025-4	NULL	D57248006010	DASSY	M	220.0000000	COLLAR,SWAGELOCKING	100
E	D57248000004 / D57248006010 / D57250208216	2	DDPT	D57250208216	L03	D57248006010	DASSY	M	2.0000000	PLUG SEALING	1000
F	D57248000004 / ABS0548VHK6-12	1	STDPT	ABS0548VHK6-12	NULL	D57248000004	DASSY	M	7.0000000	PIN,SWAGELOCKINGCSK	3000

[Anonymous · Accepted solution]

HI @mg,

I'd like to suggest you take a look at below link which mentioned about how to use path function to create custom hierarchy for analysis.

Parent-Child Hierarchies

Sample:

Level 1 =
VAR replaced =
    SUBSTITUTE ( [PathID], " ", "" )
RETURN
    PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 1 )
	
Level 2 =
VAR replaced =
    SUBSTITUTE ( [PathID], " ", "" )
RETURN
    PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 2 )
	
Level 3 =
VAR replaced =
    SUBSTITUTE ( [PathID], " ", "" )
RETURN
    PATHITEM ( SUBSTITUTE ( replaced, "/", "|" ), 3 )

Add hierarchy columnCreate custom hierarchyCreate matrix visual

Notice: I add visual level filter to remove blank value.

Regards,

Xiaoxin Sheng