isblank is not working as it should

[dudu55]

trying to "if" isblank , i want in case a value of a field is null then new column should be 1 else it should be 0 

i've dont it like that : 

counterror = IF(ISBLANK(Dudu_bi[WEIGHTDIFF]),1,0)

 in case of condition 0 is works well but for the isblank condition it gives back null value and not 1

[v-rzhou-msft · Accepted solution]

Hi @dudu55 ,

Here you use isblank to create a calculated column in 'Dudu_bi' table. Please check whether 'Dudu_bi' table has datetime 2020/04/07 13:46:53. I think your problem should be caused that there is no datetime 2020/04/07 13:46:53 in 'Dudu_bi'. So this calculated column will return blank when you add it in visual.

I suggest you to try to create a measure.

counterror = IF(ISBLANK(MAX(Dudu_bi[WEIGHTDIFF])),1,0)

You see left one is a calculated column by your code. I will get the same result like you. Right one is my measure, it works well.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@dudu55 ,  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

This formula is correct

counterror = IF(ISBLANK(Dudu_bi[WEIGHTDIFF]),1,0)