How to put single direction between 1:1 relationship

[admin_xlsior]

Hi,

I have 2 tables, which actually does have 1:1 relationship, when I put connection, it always forced me to have cross filter -> double relationship. Can we undo this ? can we force it to have only single directions. 

It is from Direct Query, and I still want to show it as two different table since it is represent tables in my backend system. However to put this as double makes me cannot add another table, it will detect active "indirect" relationship.

Thanks

[Anonymous · Accepted solution]

@admin_xlsior 

You cannot create single direction relationship with 1:1. And you should able to add another table to the model like following:

If you mean you want also add a active relationship between table2 and table3, it is not support because it would be ambiguous relationship, please refer to How to manage ambiguous relationship in Power BI – Cloud BI

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@admin_xlsior , You can make it 1-M single direction. So the table which at end of the tree make it 1.