Forum Discussion
dsynan
Advocate III
Advocate IIIBridge Table - Product and Product Components Dimensions - Unable to find relationship
I am having issues with the above model/path. 1. Fact table has the product key 2. Product Dimension (think of this as whole units) has the product key 3. The replacement Glass DIM has a...
This looks very similar to the banking scenario design with multiple customers associated to accounts and then transactions.
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
What specifically is not working that is generateing the error you provided? We might need to better understand the visual you are trying to create and the columns involved to provide some suggestions.
amitchandak
Super User
Super Userdsynan , bridge table should have between fact to fact. or fact to dimension.
Why there need join to M-M dimension. Can the other not join with fact ?
dsynanAdvocate III
Advocate IIIIt would be M-M if joined to the fact table. multiple products can use the same set of components from that second dimension table