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 da...
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.
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