Forum Discussion
Power BI Model Relationship
I've a Country table, on selection of a particular Country I want to filter my Vendor & Customer Master (which is working fine).
However, I want to filter my Sales table based on the Vendor & Customer selection. I'm not able to achieve this as one of my relationship is inactive. When I try to change it to Active, it gives me ambuiguity error.
How to achieve this type of Relationship in Power BI Modelling?
2 Replies
Think about it this way to understand the ambiguity error. If you pick Canada in the country list do you want to see the sales of customers in Canada or vendors in Canada? If both of the relationships were active the model would not know which path to take from country to sales because it could go through customer or vendor.
Your best bet is probably to have the country as a column on both the customer and vendor table. That way you could look at say all vendors in the US with sales to customers in any country or vice versa.
Hi, hatim-stovewala
May I ask if your problem has been solved? Is the above post helpful to you?
If it does, could you please mark the post which help as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
