Forum Discussion
Relationship issue
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
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.
4 Replies
v-henryk-mstfCommunity Support
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.- v-henryk-mstf
Hi Anonymous ,
Very honored to be able to help you.
Best Regards,
Henry