Forum Discussion
relationships
Hi, I have these relationships. The NCMR and the LAR both are connected to ASL by Supplier ID which I need. But each of the NCMR and the LAR has an item ID (LAR has more ID, but NCMR may have additional IDs ) that I want to connect.
I want to create a single table with showing all the NCMR and Lors dspn by material.
How do I do this?
2 Replies
I would need to see some sample data to play with. You need to redo the model. You have a bunch of many-to-many and bi-directional relationships, and both of those should be avoided at all costs and used only for specific circumstances where you fully understand what is doing on in the DAX engine. Stick to a clean Star Schema. You may need to redo the tables in Power Query or your source, which is why I suggested supplying some data to see how these tables can be restructured.
Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star SchemaHow to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumHi , gio1082
It is recommended to create another table that contains all Supplier IDs.
All other tables should use field “Supplier ID” to establish a relationship around this new table.
Best Regards,
Community Support Team _ Eason
