Forum Discussion
Datum table link
Good morning. I can't connect my datum table with a table that I created. Can you help me? THANKS.
Here is a screenshot:
4 Replies
Hi Anonymous ,
You are trying to create a direct relation between the tables Datum and Objectifs Promoteurs.
But there already exists an indirect relation between those 2 tables (through the links between the tables clients, Objectifs promoteurs, Datum and Vente). This is technically not possible in Power BI.
However, how you should tackle this, depends on the contents of your data model and what you are willing to achieve in your report. Can you share your data model set-up and some example data? That would make it easier to help you.
Hello, sorry for my late response but I was on vacation. I managed to connect the tables but the result does not suit me. I am looking to know the promoters objective per month. Here are the connections and here is the result obtained which is not correct. Indeed, in the “Sum of Objective 2024” column, the annual amount is displayed and does not take months into account. Can you help me? THANKS
Try using a single direction relationship which should be the correct direction in most cases. Other than that is hard to figure out what could be wrong with your screenshot alone.
Hi,
Thanks for the solution danextian and Smalfly offered, and i want to offer some more inforamtion for user to refer to.
hello Anonymous , base on the error meassage, is youe data source AS?, if your data source is AS, please check that if you have created the relationship in AS model, it may cause the problem, and you can refer to the follwing similar thread.
Solved: Create relationship Error "Exits outside data sour... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
