Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
NuTek
Frequent Visitor

Pass-through relationship not working... Why?

I have three tables with a relationship between each one

 

Table1

Key1

Col1

 

Table2

Key1

Key2

Col2

 

Table3

Key2

Col3

 

Relationships:

Table1(Key1) --> Table2(Key1)

Table2(Key2) --> Table3(Key2)

 

If I add a slicer on Table3's column Key2 and a table visual displaying Table1.Col1, I expected the table's contents to change when I select different values in the slicer.   They do not.    If I add Table2.col2 to the table visual everything works.

 

Why doesn't Power BI walk through the relationships from Table3->Table2->Table1 if I do not reference a column from Table2?

 

 

In SQL I can do the equivalent query and it works (see below), so why not in Power BI?

     Select Table1.Col1

       from Table1, Table2, Table3

     where Table1.Key1 = Table2.Key1

        and Table2.Key2 = Table3.Key3

        and Table3.Col3 = 'XYZ'

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Are your filter directions really unidirectional? If so, that's probably your answer, convert them to cross-filter in both directions.


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

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Are your filter directions really unidirectional? If so, that's probably your answer, convert them to cross-filter in both directions.


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

Thanks! I missed the bi-directional relationship 🙂

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors