Forum Discussion
Question about Ambiguity relationship with multiple tables
Hi leilei787 ,
If the relationship is inactive, the relationship won't work between user table and account table.
It's recommended that you follow the suggestions below.
If the relationship is inactive, when User table is filtered, it won't do filter on Account table.
As Greg_Deckler said, you can use USERELATIONSHIP in a measure if you need that particular relationship.
-
In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments.
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
leilei787 If you uncheck "Make this relationship active" then you can create the relationship. You can use USERELATIONSHIP in a measure if you need that particular relationship.
thank you. if i unchecked "Make this relationship Active" box, the relationship would be "inactive" ( dot line)....will filtering User table also do filter on Account table?
Hi leilei787 ,
If the relationship is inactive, the relationship won't work between user table and account table.
It's recommended that you follow the suggestions below.
If the relationship is inactive, when User table is filtered, it won't do filter on Account table.
As Greg_Deckler said, you can use USERELATIONSHIP in a measure if you need that particular relationship.
-
In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments.
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-