Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |