perform calcualtion with indirect relationship table data

[jja]

Hi. I have this schema:

What i want to do is to sum the weight and qty of the components by employee and different status in trasnaction table pand i don't underdtand how i could reach the weight column with this schema:

my result should look like table in this look:

Employee,status,total weight,total qty

Can you help please?

[johnt75]

You could create measures like

Total qty = SUM( Transactions[qty])

Total weight = SUMX( Transactions,
var currentProject = Transactions[projectsid]
var currentComponent = Transactions[componentname]
return LOOKUPVALUE( Components[weight], Components[projectsid], currentProject, Components[componentname], currentComponent )
)