Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have linked two tables together without problem. A table with Project & sales amount and a filtering table, that contains the projects_ID and a date.
Project_ID and Ledgeraccount are the same.
There is a specifik project, project 978400-06-03, that are in both tables, but somehow doesn't match... (Marked blue below)
A very similar project 978400-06-02, that are also in both tables, are matched without a problem (Marked green below)
What did i do wrong?
Solved! Go to Solution.
Hi @NickolajJessen,
By my tests with two tables similar to yours, it seems that everything works as expected.
Here is the output.
It seems that your relationship is not active, please active it and try again.
If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.
Best Regards,
Cherry
Hi @v-piga-msft
Thank you for your response.
From your example i realisered that my relasionship was actually inactive. Indicated by a dotted line in stead of a full line.
This was caused by some other tables having bi-directional relationships (I think)
I revised the bi-directionaltables and activated the relationship between the two tables in question and now it's working as expected!
Hi @NickolajJessen,
By my tests with two tables similar to yours, it seems that everything works as expected.
Here is the output.
It seems that your relationship is not active, please active it and try again.
If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.
Best Regards,
Cherry
Hi @v-piga-msft
Thank you for your response.
From your example i realisered that my relasionship was actually inactive. Indicated by a dotted line in stead of a full line.
This was caused by some other tables having bi-directional relationships (I think)
I revised the bi-directionaltables and activated the relationship between the two tables in question and now it's working as expected!
Hi @NickolajJessen,
It seems that you have solved your problem.
Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |