Forum Discussion

siwyan_1's avatar
siwyan_1
Regular Visitor
8 years ago

Relationship activation

 

I'm a new newbie to powerbi. Trying to activate the "yellow" relationship, but got error message as above. The rest relationships are needed, can not be de-activated. All my current relationships are 'Single" and “1：*”

 

Any thoughts?  Thank you

Need Help

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi siwyan_1,

     

    I have analyzed your table relationship like below:

    On one hand, Platform has one-to-many relationship with POSA, POSA has one-to-many relationship with FiscalYMD and FiscalYMD has one-to-many relationship with Monthly. So Platform can filter table Monthly through Platform->POSA->FiscalYMD->Monthly.

     

    On the other hand, Platform has one-to-many relationship with Monthly. So Platform can also filter table Monthly through Platform->Monthly.

     

    If the two ways of filter are based on the same column in Platform, there will exist ambiguity between Platform and Monthly.

     

    Regards,

    Jimmy Tao