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

Both C & B are dimension tables.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
    Icon for Advocate I rankAdvocate I
    4 years ago

    Not sure if this is what you call Star Schema:

     

     

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

      alisaleh 

      The filter coming from A reaches G throgh 3 different pathes. Even with B and C inactive you model is still ambiguous