Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook