Forum Discussion
EVEAdmin
5 years agoPost Patron
Double relation
Hi all I have a query with ITEMS. Each item includes: a category a subcategory Then, I have a query with CATEGORY, where the same field is used to identify the category or subcategory. ...
v-henryk-mstf
5 years agoCommunity Support
Hi EVEAdmin ,
The first thing you need to know is that only one active relationship can be created between the two tables. If you need to continue to add a relationship, you can only create an inactive relationship. According to the creation logic given in the official document, you can modify it in conjunction with your own data model.
Here is the reference document link:Active vs inactive relationship guidance - Power BI | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.