How to filter or set 3 tables relationships

[Anonymous]

Hello, 

I have 3 tables in my Power BI model, as shown in the screenshot below: Calendar, Main Records and Schedule tables. I already have the three tables connected via relationships as below via the Date field only (highlighted in blue) and it works fine when filtered by date, meaning that charts based on the Schedule and Main Records tables are updated together if the date selection is changed.

But the problem is that i also want to be able to filter by Student name (highlighted in red). The Attribute field in the Schedule table is the Student name and the list of names are the same in both Schedule and Main Records tables, so filtering by name in one table should also update the other table, but it doesn't work. I also tried to sync filters across all the charts as an alternative solution but it doesn't work either. I hope someone can help?

[PaulDBrown · Accepted solution]

Create a new table (option under "Modeling" in the ribbon with:

Student table =
VAR sch = VALUES(Schedule[Attribute])

VAR main = VALUES(Main Records[Student])

RETURN

DISTINCT(UNION(main, sch))

Create your one-to-many relationships between this new table and the corresponding fields in both tables. 
now use the field from the Student table in slicers, visuals, filters, measures....