Relationship issue

[Anonymous]

Hello Experts

I have a relationship modeling issue. The model is below

I can't understand why the relationship is working for some things but not others. It is working correctly on this dashboard

It is splitting the bins, bins counted and overall costs accross the 3 warehouses, but I cannot get it to work when splitting individual costs by items- see below

I've tried swapping and changing relationsip directions but nothing is working. I should be seeing individual costs of items that have been adjusted  by each warehouse not the overall cost of adjustments within that particular warehouse.

Here is the link to the file, hoping it helps someone figure out what I'm doing wrong!

Kind regards

Bailey14

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

It may be caused by the relationship between your tables. Change the direction of the two tables connected by Location to "Both cross filter direction".

Can correctly return results without error:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Henry

Thank you, it's fixed. Appreciate your time.

Kind Regards

Bailey14

[v-henryk-mstf]

Hi @Anonymous ,

Very honored to be able to help you.

Best Regards,

Henry

[Anonymous]

Your top table is linked to 2 other tables. It gives you no error messages but it isn't possible. You create an ambiguous model. Try linking it another way. from costs to expenses instead of making a stop in between