Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help with USERELATIONSHIP on 2 inactive relationships

Can someone clarify my thinking on how USERELATIONSHIP will handle this scenario...   Looking at the image below, I have 4 tables (part of a much more complex model), linked with many relationships...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous,

 

That is correct USERRELATIONSHIP only enables the indicated relationship for the duration of the calculation, so if you are making for example a count function when you add the USERRELATIONSHIP between employees table and job validation you will get the number of employes that are related in both tables.

 

Check the links below with further insights:

 

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

https://www.sqlbi.com/blog/marco/2013/10/01/using-userelationship-function-in-measures-and-calculated-columns-dax-powerpivot-ssas/

 

Regards,

MFelix