Circular dependency Error

[PSan1979]

Hi,

Getting a Circular dependency Error while trying to fix blank results.

[amitchandak · Accepted solution]

@PSan1979 , refer if this can help in finding out

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

[amitchandak · Accepted solution]

@PSan1979 , refer if this can help in finding out

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

[PSan1979]

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

[amitchandak]

@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)

[aj1973]

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.

[aj1973 · Accepted solution]

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.