Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Hi Henry
Thank you, it's fixed. Appreciate your time.
Kind Regards
Bailey14
Hi @Anonymous ,
Very honored to be able to help you.
Best Regards,
Henry
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |