Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |