Alternatives to show BLANK() -- to be able to use this in Metric

[Saniat]

Hi,

In some cases, my calculation returns null / blank and is displayed as BLANK().
I wanted to avoid it and converted this as a text e.g. IF( ISBLANK(MyMeasure) , " ", MyMeasure)

I also do not want to report zero instead of null.

Problem with this approach is I then cannot use this field in my Metrics - as it is a text field.

Is there any better way to deal with these BLANK(), so I do not show anything when it is BLANK(), and can also use this field in the Metric ?

Many thanks !

[Saniat]

After some search over the internet, I found a soln to it:
I am using this measure in the color function, and matching the background color when I do not want the BLANK() to be shown:
MyMeasure = 

IF(

    ISBLANK('1'[OtherMeasure])

    , 1

    , 0

)

[Arul]

@Saniat ,

Do you want to show 0 instead of " "? If yes then add +0 at the end of your measure.

Thanks,

Arul

[Saniat]

Unfortunately I cannot report 0 where I do not want to report, I want to report NULL.