Forum Discussion
Helper IIInactive relationships : When multiple relationships are to be done
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 :)
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.
5 Replies
- Greg_Deckler
Community Champion
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
Memorable Member
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.
Great solution konstantinos @!! It worked for me as well.
