Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |