Forum Discussion
maxduff59
Helper II
3 years agoSeveral relationships between tables but filtering does not work
I am a newbie on Power BI and I am facing some difficulties about creating a good modelisation for my different tables. To explain a little bit my data, I have operations which can be made of (sale...
maxduff59
Helper II
3 years agoI did not really understand your answer, I'm sorry 😕
PaulDBrown
Community Champion
3 years agoIt is highly recommended to avoid many-to-many relationships in a Power BI model, since they can lead to unexpected results and inevitable headaches. You can avoid them by creating dimension tables containing a field of unique values which are common to the fact tables (for example you can create a dimension table for Seller ID since it is common to Loans, Sales and Orders).
Check out these resources:
https://radacad.com/basics-of-modeling-in-power-bi-what-is-a-dimension-table-and-why-say-no-to-a-single-big-table
https://www.sqlbi.com/articles/start-learning-data-modeling-for-free/
https://exceleratorbi.com.au/create-lookup-table-power-pivot/