Forum Discussion
Helper IVHelp With "A Circular Dependency Was Detected" Error
I have a calculated column with this formula and it works fine:
Hi, krichmond
You can try the following methods.
Uninsured Marketing Designator = IF(LEFT(mv_perfex[clientgroup], 2) = "UI", 1, 0)Uninsured Marketing Quantity = IF ([Uninsured Marketing Designator]=1, mv_perfex[Marketing Quantity])Also try:
Uninsured Marketing Designator = IF(LEFT(mv_perfex[clientgroup], 2) = "UI", TRUE(), FALSE())Uninsured Marketing Quantity = IF ([Uninsured Marketing Designator]=TRUE(), mv_perfex[Marketing Quantity])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
krichmond , seem like Uninsured Marketing Quantity is used in columns that have used to generate this , indirectly
refer: https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. 
v-zhangtiCommunity Support
Hi, krichmond
You can try the following methods.
Uninsured Marketing Designator = IF(LEFT(mv_perfex[clientgroup], 2) = "UI", 1, 0)Uninsured Marketing Quantity = IF ([Uninsured Marketing Designator]=1, mv_perfex[Marketing Quantity])Also try:
Uninsured Marketing Designator = IF(LEFT(mv_perfex[clientgroup], 2) = "UI", TRUE(), FALSE())Uninsured Marketing Quantity = IF ([Uninsured Marketing Designator]=TRUE(), mv_perfex[Marketing Quantity])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
