Forum Discussion

alisaleh's avatar
alisaleh
Advocate 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 & G is the active one, however B,C are inactive so Im trying to create a measure that filter based on both B & C but if I use the USERELATIONSHIP function on both B & C I get ambigous error which makes sense. The question how I do resolve this issue? Do I have to create two different measures?

Need Help

10 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi alisaleh 
    No it doesn't make sense unless there are other tables involved or other relationships between dimentions or both?

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        alisaleh 
        You are describing a star schema model where 3 dimentions are connected to one fact table via one to many relationship. If this is the case you should be able to have them all active at the same time with no issue. Would you please share a screenshot fo better understanding.

  • alisaleh's avatar
    alisaleh
    Advocate 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

      • alisaleh's avatar
        alisaleh
        Advocate I
        4 years ago

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