There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. In this video, we compare the performance of both options.
Article and download: sqlbi.com/articles/different-options-to-model-many-to-many-relationships-in-power-bi-and-tabular/?aff=yt
How to learn DAX: sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
- Different options to model many to many relationships in Power BI and Tabular ( Download)
- How to manage Many-To-Many relationships in a Data Model |Data Modeling Tutorial |BI Consulting Pro ( Download)
- Looking at Power BI Many to Many ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- Handling Many to many relationship issue in Power BI | Power BI for Beginners ( Download)
- Many to many issues and alternatives in Power BI ( Download)
- Understanding Relationships in Power BI // Beginners Guide to Power BI in 2021 ( Download)
- 2 EASY WAYS to FIX MANY to MANY relationships in POWER BI // Beginners Guide to Power BI ( Download)
- Answering questions: another option for many to many relationships in Power BI - Unplugged #39 ( Download)
- Scenario based on Many-to-many relationship | Power BI Interview ( Download)
- Power BI Many-to-Many Relationships: Issues and Fixes Explained | MiTutorials ( Download)
- Many-to-Many Relationships - The Whiteboard #12 ( Download)
- DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship ( Download)
- Power BI Feature Highlight: Many to Many Relationships! ( Download)
- Different types of many-to-many relationships in Power BI - Marco Russo ( Download)
