Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |