How to connect two tables with having the foreign keys twice in the table?

[mincii]

Dear Community

I am stucking into one problem to create new measures with project number.  I have a Project table containg a information about projects. One table with delivery note with project_from and project_to. This delivery note has a linked table with all position containg. 

Each Position has a quantity - and I want to put_from project an project_to an plus. But I just have the delivery note type as number 3. 

My Measure: 

Anzahl_N = IF (deliverynote = 3) , SUM(PROJ_NWP[ANZAHL]) * (-1.0), SELECTEDVALUE(PROJ_NWP[ANZAHL]))

 All Project in both columns do the minus, but I want to separate it.

Does anyone have an idea? If needed sample data I am going to paste it here.

Thanks. 

BR

[mincii]

Expected Results:

If  "Lieferscheintyp =3" than "Anzahl" should be for the "VonProject" minus Quantity and for the "AnProject " plus quantaty. 

Backround: The products are going to be send to different locations, so I have to figure out, where the goes away and where it come to which project. 

Hopefully I explained it clearly. 

Thanks

BR

BR 

[serpiva64]

Hi, Please paste sample data and the expected result.