Forum Discussion
Post ProdigyHow to put single direction between 1:1 relationship
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
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.
2 Replies
- amitchandak
Super User
admin_xlsior , You can make it 1-M single direction. So the table which at end of the tree make it 1.
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.
