Inactive relationships : When multiple relationships are to be done

[adrien5555]

Hi all,

All the data must be seen by date, and by location, basically. So based on your good advice, I created a "date" table with all dates, and a "country" table with all countries. 

All data tables points towards these 2 tables : date and countries.

Problem is that to PBI it appears as 2 different path to connect data tables, and I get the following error when I try to activate the relationship:

Relationship Activation 

You can't create a direct active relationship between DataTable1 and Continents and countries because that would 

introduce ambiguity between tables DataTable2 and Datatable1. To make this relationship active, deactivate or delete one of the relationships between DataTable2 and DataTable1 first. 

Thanks for your help 🙂

[Guilligam]

Great solution @konstantinos @!! It worked for me as well.

[Greg_Deckler]

Any chance you can post an image of your data relationship model?

[adrien5555]

@Greg_Deckler: Sure 🙂 As you can see below, the 2 tables can already relate to each other thru the "Date" table, which seem to cause the relationship to be deactivated when I create it.

[konstantinos · Accepted solution]

@adrien5555You need to make one  of the below relantionship "Single" filter direction istead of "Both".

Dates 1:* BusinessReportAmazom

or Continents and countries 1: BusinessReportAmazom

The problem if the relation was active then the filters from this table could went through Dates or through Continents table and there is no way the engine to know which should follow so it gives an error.

[pandiarajan]

very useful solution thank u very much