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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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