Forum Discussion

leilei787's avatar
leilei787
Helper II
3 years ago
Solved

Question about Ambiguity relationship with multiple tables

Hello, i am trying to solve a problem with ambiguity relationship problem. Hoping someone could help

 

i have three tables: User Table from SFDC, Shipping detail table and Account table from SFDC.

 

The Account table is connected to Shipping detail table through Account Number because i need Total Addressable Market (TAM) info from the Account Table. ( TAM is not in the shipping table because different sources)

 

The user table is for RLS purpose. it is connected to shipping table with many to many relationship ( mostly because we are allowing territory manager to see their whole region, not just their accounts). The connection is through region combined ( ID& Region Name)

 

Now if i want to connect the User table to Account table....PBI tells me that i can not because it will introduce ambiguity between Account and Shipping table......i need to deactivate or delete the relationship between Account and Shipping tables. (see screenshot below)

 

The reason i need to connect User SFDC to Account table is because somehow TAM info in Account is still showing when a territory is viewing the regions other than his/her.

 

any thoughts how to approach this problem? thank you all!

 

Overall relationship screenshot

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.