cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vanessa250919
Helper III
Helper III

Userelationship in table

Hello, I have one question in my table in AGENT name I have no data beacause my table "Employee" is in no active relation with my fact table because I have to fact table . For the measure I use USERELATIONSHIP( but if i want see the AGENT in table and no in measure I can't ... One idea ? 

 

Vanessa250919_0-1616520556275.pngVanessa250919_1-1616520593267.png

 

1 ACCEPTED SOLUTION
edhans
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors