Relationships and Dim Table issues

[shanewest]

I am working with a PowerBI model in which I have 2 separate tables with multiple relationship types, tied to two dimension tables. The two dim tables are a Calendar Table and a unique Route table, which have relationships between the two other tables as a bridge. I have the Dates relationship active, so that I can filter all my results by date, however, I also need to be able to filter them by Route. However, when I look at the two visuals I'm trying to monitor, one for the entries detailing the issues for a specific route on a specific day, and the other the on time performance of a route on a specific day, I can't filter the on time performance by route. The entries change, but the routes remain the same. All the data changes with the Dates, as expected. Is there a way to make this work?

[shanewest]

Thanks for the help! I misunderstood the relationships. Once I fixed that as you suggested, the data is now communicating with each other.

[lbendlin · Accepted solution]

Read about star schemas.  Clearly identify your dimension and fact tables. Only use 1:* single direction relationships.