Forum Discussion
Solved
Adding values to a sum between tables
Hello, I have a dataset that contains two tables that connect to a fact table. Table 1 - Project Information with a One-to-Many relationship, and Table 2 - Project Information with a One-to-One. ...
That looks like something I would have written. Glad it is working.
The only thing I would tend to do differently is use variables when I have measures with multiple calculations in them. It allows me to easily test the components of a measure to find which parts work and which parts are "broken".
My first suggestion would be to review the cross filter directions of the existing relationships. It sounds like one of the product ID columns is trying to filter a table that it cannot.
Here is a snippet of just the related tables. The only one I can edit is the one-to-many with Archive Labor, but I didn't notice any difference when changing that one between single and both.