Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have created relationship like below,in this i have unique dates in date table and other have duplicate date values:
but i am getting below error while i pull the dates of the columns which have duplicate dates:
how can i create a relationship so all 3 of my dates will be in sync?
Thanks,
Neeraj
Solved! Go to Solution.
Hi @jatneerjat,
I created some tables as you described. Based on my test, I can reproduce the issue the same as you by pulling duplicate dates from different tables into one visual.
Actually this is a known issue in Power BI when using groups from a chain of N:1:N relationships. The issue could be fixed by changing the fields from don’t summarize to other options. Also we can work around this issue by adding a model measure to the visual. The DAX generation logic for visual queries treats model measures as if they could relate any combination of groups. Therefore, adding a model measure to a visual effectively disables the check for unconstrained joins that is triggering the error message shown below.
For more details, please check the pbix as attached.
Regards,
Frank
Hi @jatneerjat,
I created some tables as you described. Based on my test, I can reproduce the issue the same as you by pulling duplicate dates from different tables into one visual.
Actually this is a known issue in Power BI when using groups from a chain of N:1:N relationships. The issue could be fixed by changing the fields from don’t summarize to other options. Also we can work around this issue by adding a model measure to the visual. The DAX generation logic for visual queries treats model measures as if they could relate any combination of groups. Therefore, adding a model measure to a visual effectively disables the check for unconstrained joins that is triggering the error message shown below.
For more details, please check the pbix as attached.
Regards,
Frank
Hi @v-frfei-msft,
It works when i use this date values in slicer but when i drag this into the table then it gives error message as posted by you so i think it worked for me as i removed dont summarize option.
thanks
Hi @jatneerjat,
Does that make sense? If so , could you please mark this answer as a solution?
Regards,
Frank
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |