Relationship Issue between two tables in Power BI (Ambiguity issue)

[rameshmadhubhas]

Have the following tables in the Power BI data model:

1. Transaction

2.Buyer

3. Manufacturer

The requirement:

when I select the relevant region want to show the corresponding total transaction amount on the card.

The slicer should include all the regions that came from both buyers and manufacturers.

Created the other table Regions, using the following query and added the relationships as follows:

Regions = CALCULATETABLE(UNION(SUMMARIZE(Buyer, Buyer[Regions]), SUMMARIZE(Manufacture, Manufacture[Regions]) ))

Problem:
Can't create an active relationship between Buyer and Region. Therefore, unable to filter the transaction amount correctly.

Therefore, I expected the correct way to solve this issue without changing the data model and relationships among the Buyer, manufacturer, and Transaction tables

[v-binbinyu-msft]

Hi @rameshmadhubhas ,

There is no problem for "Can't create an active relationship between Buyer and Region."

Relationship in power bi is different than other databases, it has direction for relationships(e.g, single filter direction, filter effect from one side to other side; cross filter direction, each side can effect correspond column).

Power bi will try to analytics data model and summary records through relationships.

If your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

Best regards,
Community Support Team_Binbin Yu