Forum Discussion
Userelationship in table
Are you asking why you have no active relationship between your Employee and FACT table? It is because of those bi-directional relationships. Your model has ambiguity and it deactivates any relationships it cannot use automatically. In order to use them in a measure, you use the USERELATIONSHIP() modifier within a CALCULATE() but it only works in CALCULATE measures, and that can cause issues depending on how you want to create visuals like slicers. You cannot activate relationships for slicers and filters.
Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star Schema
Are you asking why you have no active relationship between your Employee and FACT table? It is because of those bi-directional relationships. Your model has ambiguity and it deactivates any relationships it cannot use automatically. In order to use them in a measure, you use the USERELATIONSHIP() modifier within a CALCULATE() but it only works in CALCULATE measures, and that can cause issues depending on how you want to create visuals like slicers. You cannot activate relationships for slicers and filters.
Microsoft recommends minimizing use of both Many-to-Many and Bi-Directional Relationships. In other words, unless you are a DAX expert, find another way to remodel your data to conform to a Star Schema and don't use these two features. I avoid them both at all costs.
Microsoft Guidance on Many-To-Many Relationships
Microsoft Guidance on Bi-Directional Relationships
Microsoft Guidance on Importance of Star Schema