Relationship & filters

[Prabha45]

I have 4 tables, each table is having site, department and date column. I created a many to many relationship between these tables using site column. There are 3 slicers site, department and date. Site and department are filtering every table, but the date filter is filtering only the table from which the date column is selected. What needs to be changed to filter every table when a date is selected.

Thanks

[amitchandak]

@Prabha45 , You should create common dimensions and 1-M joins

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...