Forum Discussion
Problem with creating a satisfactory relationship model
- Anonymous8 years ago
noyrotbart,
Please review my reply in the similar thread below.
http://community.powerbi.com/t5/Desktop/Can-t-create-direct-active-relationship/td-p/148425
Regards,
Lydia
noyrotbart,
Could you please post the full error message in Power BI Desktop?
Regards,
Lydia
Sure:
"You can't create a direct active relationship between Gifts and contact because an active set of indirect relationships already exists between these tables. To make this relationship active, set the Cross filter direction to "single", delete, or deactivate any of the indirect relationships first".
(At this point I also note that one can't copy the errors :))
- Anonymous8 years agoNot applicable
noyrotbart,
Please review my reply in the similar thread below.
http://community.powerbi.com/t5/Desktop/Can-t-create-direct-active-relationship/td-p/148425
Regards,
Lydia- noyrotbart8 years agoFrequent Visitor
Well, one can pass that with a many to many relation at least, no?
- Anonymous8 years agoNot applicable
noyrotbart,
In Power BI Desktop, you can create many-to-many relationship between tables with the help of bridge table.
Regards,
Lydia