How to change "Blank" to "0" value?

[Zaky]

Dear Experts,

Is there any chance to make the "(Blank)" instead to be set as "0" value?

[belisqui]

I know it is annoying but I think the best way is to create a second measure_NoBlank. Creating another measure is better becuase if you still want to use it in a table or chart you won't get many dimensions with 0 next to it.

Something like this:

Offshore Sites = SUM(Offshore[Sites])

Offshore Sites_NonEmpty = IF([Offshore Sites]=BLANK(),0,[Offshore Sites])

Use the Offshore Sites_NonEmpty in your card.

[prakash11440278]

Hi @Zaky,

Please try to add "+0" to your measure or IF(isblank(offshoresites),0,offshoresites).

[Zaky]

@prakash11440278 

Current measures that i'm use is as below.

So how can i add on to the current measure? 

#POS Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "physically on-site"})

#RET Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "require engineer to travel"})

#OFF Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "offshore"})

[belisqui · Accepted solution]

Keep those as it.

Create 3 new measures

#POS Measure_NonEmpty = IF([#POS Measure] = BLANK(),0,[#POS Measure])

#RET Measure_NonEmpty = IF([#RET Measure] = BLANK(),0,[#RET Measure])

#OFF Measure_NonEmpty = IF([#OFF Measure] = BLANK(),0,[#OFF Measure])

Replace the measure in your cards by these ones.

[Zaky]

@belisqui 

Wonderful!  Managed to follow the advised.

Thanks dude!

Regards,

Zaky