Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I keep running into: A circular dependency was detected: Consumer[Companyname], Consumer[Companynameknown], Consumer[Companyname].
Here is a simplified view of the tables used (with the Companynameknown as desired column).
Companytable:
companyID | CompanyName |
|
|
1 | Aaa |
|
|
2 | Bbb |
|
|
3 |
|
|
|
4 | Ccc |
|
|
5 |
|
|
|
6 |
|
|
|
7 | ddd |
|
|
Consumer table
Companyid | Companyname | Consumerid | Companynameknown |
|
24 | Abc | 544 | Yes |
|
44 |
| 545 | No |
|
69 | Bcd | 546 | Yes |
|
178 | Dff | 547 | Yes |
|
244 | Etc | 548 | Yes |
|
Where in the Consumer table:
Companyname = LOOKUPVALUE(Companytable[CompanyName],Company[companyID],[companyid])
I tried to get the Companynameknown based upon the content of the Consumer[companyname] column ->
Companynameknown= if(Consumer[Companyname]<>blank(),"yes","no").
Based upon articles in the forum I tried to achieve this with e.g. measures, with allselected, etc. etc. but keep running into the same error message. For me it is not an option to remove the relationship between the tables.
All suggestions are welcome!
Thanks in advance
(worst)Kees
Solved! Go to Solution.
Hi @Worstkees ,
Since you have established a relationship between Consumer table and Companytable, please try using the RELATED function.
Companyname =
RELATED ( Companytable[CompanyName] )
Companynameknown =
IF ( [Companyname] = BLANK (), "yes", "no" )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Worstkees ,
Since you have established a relationship between Consumer table and Companytable, please try using the RELATED function.
Companyname =
RELATED ( Companytable[CompanyName] )
Companynameknown =
IF ( [Companyname] = BLANK (), "yes", "no" )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Worstkees , if Companyname is in Consumer table as column
this should work as a new column
Companynameknown= if(isblank(Consumer[Companyname]),"yes","no")
Thanks @amitchandak ,
Unfortunately this still gives me the same error:
All suggestions are welcome!
Thanks,
(worst)Kees
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |