Forum Discussion
Cannot create active relationship between date table and multiple dim tables
You are doubling relationships if you make connection to dimtables and between data tables.
Model works if you delete many to many and connect 🙂
Partially you re correct to use dimdate. The end goal to use dimntables to avoid many to many relationships. For 90% they are responsible why the relationships are blocked. There should be notification which relationship is blocking you table link, double click on not active ones
What is the column link for relationships between them? Project id or something like that? Try to create new table and use within it dax with distinct union. Connecting them to new dimtable and removing many to many relationships could help.
You are doubling relationships if you make connection to dimtables and between data tables.
Model works if you delete many to many and connect 🙂