Forum Discussion
Solved
Multiple relations
hi guys!! I have many tables with following relations: I am doing this table: I'm not able to obtain the correct result, I don't understand how to work with ...
- Thanks so much, If it Work i ‘ll tell you
Okay this is how I would solve this. I would remove the inactive relationships and only relate tables in one direction.
Ex: 1 ->* and not bi directional. This will speed up the performance of your report.
Second I'd create a distinct Product Code Table (=Distinct('productos'[prodcodigo])) to relate to productos, ops, and decargas.
Use the Products field in the product code table as the rows in your matrix. That shoudl solve your circular dependancies.
Then use a measure as your value to something like SUM(detcargas[dcarproducto])-SUM(ops[op_producto_codigo]).
If that dosen't work i may need your pbix to try and solve it.