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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

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.


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks! I missed the bi-directional relationship 🙂

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.