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 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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?

  • 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: