How to deal with (Blank), -nan(ind)?

[powerbiasker]

When Power BI encounters NULL, nonexistent or empty values, it could show (Blank) or -nan(ind).

I want to let it be 0 if (Blank) and let it be "N/A" if -nan(ind)?

Use DAX isblank(), isrerror() and IF() to deal with them?

[amitchandak · Accepted solution]

try like iferror(If(isblank([Measure]),0),0)

https://docs.microsoft.com/en-us/dax/iferror-function-dax

[Anonymous · Accepted solution]

Measure 2 = IF(ISNUMBER(Your_Value) = FALSE(), "N/A", IF(Your_Value = BLANK(), 0))

[amitchandak · Accepted solution]

try like iferror(If(isblank([Measure]),0),0)

https://docs.microsoft.com/en-us/dax/iferror-function-dax