How to check blank and empty value in dax

[sandip]

Hi,

I am using below DAX

Return Type =

var vTxt = IF(ISEMPTY(CALCULATETABLE(SAVO_QBR_TEMP, SAVO_QBR_TEMP[Return_Type]<>BLANK()))=False, SAVO_QBR_TEMP[Return_Type], "NULL")

return IF(vTxt<>"NULL" && not ISBLANK(SAVO_QBR_TEMP[Return_Type]), SAVO_QBR_TEMP[Return_Type])

and My values are showing as below:

but it does not working. Please help in this case.

[Ani1991]

hI @sandip 
Try using the function ISBLANK().

Thanks.

Ani

[sandip]

Hi,

I am doing the below DAX and it is not working properly:

IF(NOT ISBLANK('SAVO_QBR_TEMP'[Return_Type]) ,'SAVO_QBR_TEMP'[Return_Type])

Please advise what to do now?

[Ani1991 · Accepted solution]

Hi @sandip 
Please check this.
I didn't get your DAX expression. I guess you are creating a measure to check the functionality. Try creating a calculated column.
I created some dummy data with some progress column values as blank.
I created a calculated column like below,

BLANKCHECK = IF(ISBLANK(Dummy[Progress]),0,Dummy[Progress])
Here is what I get,

I have replaced the blank values with 0 in the BLANKCHECK column.

Hope this helps!!

Thanks,

Ani