Forum Discussion
Impactful IndividualAmbiguous path - Don't understand why
Hi DouweMeer , Thank you for reaching out to the Microsoft Community Forum.
Instead of separate bridge tables between your red filter and Customer/Product, build a single Customer Product bridge dimension that links both Customer and Product to Fact. Then connect your red filter table to this composite dimension. This removes ambiguity and correctly represents the many-to-many relationship between Customer and Product without circular dependencies.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Community SupportHi DouweMeer , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.