Data Modeling Issue

[shashiPaul1570]

Hi Team, 

I am working on a data where I am having around 13 tables and getting many to many relationship cardinality.   I have created a bridge table among 2 tables however not getting solution about others as it's giving me many of many relationship.  Please share your best practices on this.  (Note: I don't have access to  make changes as source level as using S

[shashiPaul1570]

[amitchandak]

@shashiPaul1570 , You do not have two join two fact/transactional table, You need join them using common tables only

refer i done something here

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Share data model for more help

[shashiPaul1570]

Hi Amit, 

Thank you for your response however I am still stuck with the same problem. Actually I am having 11 tables and  around 9 have many to many relationship.   Bridge table is one of the solution however  I will have to create bridge table for each situation where  I am trying to have relatioship with 2 fact tables.  

I am attaching a screenshot where I have created a bridge table though I will have to make it BI-directional.