cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adrien5555
Helper II
Helper II

Inactive 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 🙂

 

1 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.

Konstantinos Ioannou

View solution in original post

5 REPLIES 5
Guilligam
Frequent Visitor

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

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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.

 

 

test1.png

@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.

Konstantinos Ioannou

very useful solution thank u very much

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors