Forum Discussion
Filter one table from different tables
[ Spoiler ] Hi all, I have four related tables to be modelled in the following manner. But not able to do as it is creating circular filtering across the tables. What is the best way I can handl...
You cannot create filters like that. It will create ambiguity, as you've found. You need to try and develop your model as a Star Schema.
Within Power Query you should build the tables you need then only load what you need into DAX, then relate those with a FACT table surrounded by DIM tables. SQLBI has written an entire book on this and has a course on it.
I literally spend hours whiteboarding how the model will look and how to pull in the right data. I NEVER just grab 15 data sources, load 15 tables, then start connecting them in the Power BI modeling tab. I spend a TON of time in Power Query shaping the data to get it down to what I really need in DAX. Then my measures become pretty easy.