table is missing the record in the relationship

[SaschaVC]

Dear all,

I have an issue between 3 tables (see picture)

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

[Tahreem24]

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

[SaschaVC]

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.

[SaschaVC]

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]

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