Relationship activation

[siwyan_1]

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

[v-yuta-msft]

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