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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors