Using redundant relationships

Sorry for the misunderstanding question.

Thanks for your reply, but that isn´t my desired goal.

I took your File, filled it with some more informationen (e.g. costs and causer) and created the final table.

Here you can see, that 100€ aren´t assigned to any causer.
In Table1 you can see, that these 100€ don´t have a causercode, but a Order.
And in Table2 you can see, that these Order is assigned to workplace AW1 and to the causercode V08.
And in Table3 you can see, that causercode V08 is assigned to the causer "cause2".

So in the free field I want the causer "cause2"

I hope you understand my problem now.

I can´t upload a .pbix-file. so I have to send pictures.

Table1
Table1
Table2
Table2
Table3
Table3
Relationship
Relationship
Desired Goal
DesiredGoal