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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |