Forum Discussion
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 re...
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