WBS and Weighting

[Anonymous]

Hi,

I have the typical WBS and weighting for different level in  two different table. I have link up Lvl 1 and Lvl 2.

Any solution to calculate the project weight at Level 2 using DAX formula? It will give me an error when mulitpy  Lvl1 weight and Lvl 2 weight in DAX.

Project ID	Lvl 1 ID	Lvl 1 WBS DESC	Lvl 1 Weight
101	1.1	Engineering	0.2
101	1.2	Procurement	0.3
101	1.3	Construction	0.5

Lvl 1 ID	Lvl 2 ID	Lvl 2 WBS DESC	Lvl 2 Weight	Project Weighting
1.1	1.1.1	MDR	0.4	0.08
1.1	1.1.2	PDMS	0.4	0.08
1.1	1.1.3	Procurement Engineering	0.2	0.04
1.2	1.2.1	Equipment	0.6	0.18
1.2	1.2.2	Bulk Material	0.4	0.12
1.3	1.3.1	Topside Module	0.35	0.175
1.3	1.3.2	Hull Conversion	0.4	0.2
1.3	1.3.3	Integration	0.25	0.125

New in DAX and Power Pivot

JS

[Icey · Accepted solution]

Hi @Anonymous ,

If I understand you correctly, the column "Project Weighting" you provided is what you want to calculate using DAX. 

If so, you can create a column like so:

Column = LV2[Lvl 2 Weight] * RELATED ( LV1[Lvl 1 Weight] )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Icey,

Thans!. Its help.

JS