Why can't i make this relationship active?

[Majad_Chowdhury]

Hi,

I thought i made a fairly basic data model however power bi is not liking it. 

I have a date dimension that connects to both the middle tables using YYYYMM columns.

I then have a another table called DimMetricType which i want to connect to the middle 2 tables. The top middle table gives me actuals, the bottom middle gives me projected and targets hence why i am trying to connect the "DimMetricType" table so i can scroll through my metric types and have the actuals, target and projected change.

[Alex87 · Accepted solution]

The fact that you have bi-directional relationships between the tables Metrics summarized / Date Dim and Date Dim / fact_Marketing creates ambiguity in the model. You can add an active relationship between Dim_metrics and fact_marketing if the other relationships are not bi directional. Tip: many to many relationships is not best practice. Use the day date for the relationship from DateDim so that you can obtain one to many relationship.

If my post answers your query, please mark it as a solution.

Best regards,

Alex

[Majad_Chowdhury]

You were right! I changed my relationships from using YYYYMM to dates as this would enforce a 1 to many relationship and it done the trick!

Thanks for your help!