Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
@SaschaVC Can u make the cross filter direction to "Both" ? so It will read data from both the sides.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |