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 are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.