Forum Discussion
Solved
Circular dependency Error
Hi, Getting a Circular dependency Error while trying to fix blank results.
PSan1979 , refer if this can help in finding out
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Also, the LOOKUPVALUE can return "Others" for Blank, you just need to add it in your formula.
may be the fact that you are using If is Blank over LOOKUPVALUE is causing the Circular Error.
Hi There,
it looks like the LOOKUPVALUE formula is not used correctly.
please check out this link
https://dax.guide/lookupvalue/
And try to execute the formula sepratly from the IF function and see if it works.
Also, the LOOKUPVALUE can return "Others" for Blank, you just need to add it in your formula.
may be the fact that you are using If is Blank over LOOKUPVALUE is causing the Circular Error.