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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
SaschaVC
Regular Visitor

table is missing the record in the relationship

Dear all,

I have an issue between 3 tables (see picture)

2023-09-08 12_35_28-Window.jpg

Most of my data has a relation from A to B to C and for those everything is working well.

But there is also data/records in C where there is no link in B to A.

Those data/records are not showing up in my results.

How can I solve this problem?

 

Thanks in advance for your appreciated help

 

 

4 REPLIES 4
Tahreem24
Super User
Super User

@SaschaVC Can u make the cross filter direction to "Both" ? so It will read data from both the sides.

 

Tahreem24_0-1694507013733.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
SaschaVC
Regular Visitor

Dear, I have 10225 records in table A,

8350 are linked to table A via table B,

only 1875 records are directly linked to table A.  

 

If I create a relationship A-B and A-C, then I have 8350 records in table C without a connection to A, because the connection is made in table B.

 

I was thinking at a formula to enter in an extra column in table C... if there is a parent ID in Table B enter the parent ID from table B, if there is no parent ID in Table B, Lookup parent ID in table A and enter the parent ID from table A.

As such all records from C should have the connection to table A.  But I don't succeed in this formula.

 

 

 

Correction on my former message:

 

Dear, I have 10225 records in table C,

8350 are linked to table A via table B,

only 1875 records are directly linked to table A.  

 

If I create a relationship A-B and A-C, then I have 8350 records in table C without a connection to A, because the connection is made in table B.

 

I was thinking at a formula to enter in an extra column in table C... if there is a parent ID in Table B enter the parent ID from table B, if there is no parent ID in Table B, Lookup parent ID in table A and enter the parent ID from table A.

As such all records from C should have the connection to table A.  But I don't succeed in this formula.

chonchar
Helper V
Helper V

Hi,

 

Maybe I can help.

 

A should be the fact table. B and C should both be dimension tables. 

 

So, A should connect (lookup to) B and C individually. My understanding of what you explained is that:

A is connected to B and B is connected to C.

 

That passes the filter context through both tables simulatneously which is not good. 

 

A should be connected to B and A should be connected to C.

 

Hope this helps,

 

Cam

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.