Forum Discussion
Circular dependency Error
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.
PSan1979 , refer if this can help in finding out
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Sir, They have given eg in measure. but my issue is I have already calculated and just want to assign Blank() as "Others", when i try to use IF(ISBlank(Col_name), "Others","Student") that time i am getting an error
PSan1979 , check this lookup value alone, is it working?
If not is any of these three-column driven from each other?
or the table itself.
If you have created a table using a select column and using that again. If you have created one table from another use distinct or summarize to make use it is no more a reference
if lookup is working then move its var and check that into you formula
New column =
var _1 = lookupvalue(..)
return
if(isblank(_1), 1,0)
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.
