in my problem, there are three tables with an redundant relationship. (You can see the problem in the attached picture)
The target is to assign the costs from Table1 to a causer in Table 3.
When the Bew.Art is 553, the causercode is V01.
When the Bew.Art is 551 and there isn´t a Order, the causercode is V15.
When the Bew.Art is 551 and there is a Order, it depens on which Workplace the order was edited. And then the Workplace decide about the causercode.
And because of the causercode in Table1 oder Table 3, I have to connect both to Table 3.
I know, the tables aren´t modeled in the best way, but that´s an requirement, not to change these tables.
Is it possible to solve this problem without changing the Tables, maybe with a Dax-formula?
("USERELATIONSHIP" or something like that?)