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

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

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.

Top Solution Authors