Filter multiple queries using same column

[jatpola]

Hello, I suppose this is a basic question, but I haven't been able to search for it properly I have many tables with a common column ("Brand"). I'd like to filter the report by brand, without having to filter every table one by one. How can I tell the model that the "Brand" column is shared by every table, and thus should filter everything when I select a brand to show? I hope my question is clear. Thanks!

[amitchandak · Accepted solution]

@jatpola ,Create a common Brand Table

https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified

https://www.youtube.com/watch?v=Bkf35Roman8

Join Brand with Brand in all the tables and then filter brand from brand table.

https://www.youtube.com/watch?v=vZndrBBPiQc&feature=youtu.be

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/