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 fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.