Matrix Values Incorrect - Would this be an issue in the data model?

[Anonymous]

So in this matrix above, the first 3 values (underlined in blue) are calculated correctly for the UIDs under project name (the hierarchy is project name, project number, then purchase order number... all from different tables). The problem is the calculations for the values underlined in red.... As you can see from where I started highlighting, the values are all calculating as identical for all of the purchase order numbers. This is incorrect. For example, the purchase order 24672 is the only one that should have a value of $4,000 under "Cost-Posted-Accrual-Amount@1"... the others should be blank. That value is pulled from a different table, connected through an intermediate summary table between them (where the project number 102003 comes from, under the project name: Construction Management Funding).

Could someone point me in the right direction of where to look to fix this issue? I'll include another screenshot of my data model below. For the Hiearachy for the Project name (the matrix rows), the Project Name comes from the leftmost table, the Project Number comes from the CAPEX Metrics table, the Purchase Order Number is coming from the CAPEX_OpenPOs table, and the other values are coming from the other CAPEX tables. The only values that are correct in the matrix are those that come from the CAPEX_OpenPOs table, which tells me there's definitely something wrong with how I have this set up.

[Greg_Deckler]

@Anonymous it's tough to tell from the information provided but nine times out of ten what you are experiencing is due to a missing relationship path between two tables. So if Projects is your project and you get the PO # from CAPEX Payments, then CAPEX Payments needs a relationship path to the other CAPEX tables that contain the numbers for that PO # and I believe that is what is missing.

[Anonymous]

Thanks Greg, this solved it!