Forum Discussion

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
4 years ago
Solved

ambiguous Relationship using DAX USERELATIONSHIP function

Hi, I'm new to power bi so sorry if this sounds stupid. I'm working with complex model. I have table lets say called G and it has *:1 relationship with three tables A,B&C. the relationship between A...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    alisaleh 

    Can you share a screenshot of the current relationships situation 

alisaleh's avatar
alisaleh
Icon for Advocate I rankAdvocate I
4 years ago

I understand its ambiguous but I mentioned its a complex model that is very interconnected. The question what do you do if you want to be able to filter G by A,B & C . A will work because is active relationship

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    alisaleh 

    Deactivate A-B and A-tag_ITR

    • alisaleh's avatar
      alisaleh
      Icon for Advocate I rankAdvocate I
      4 years ago

      I tried it but it doesnt help. I still cant use a measure on G with USERELATIONSHIP from B & C.

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        alisaleh 

        Can you share a screenshot of the current relationships situation