cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

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

Dear Experts,

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

 

capture1.JPG

 

 

 

1 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.

View solution in original post

5 REPLIES 5
Advocate IV
Advocate IV

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.

 

Hi @Zaky,

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

@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"})

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.

View solution in original post

@belisqui 

 

Wonderful! Heart Managed to follow the advised.

 

Thanks dude!

 

Regards,

Zaky

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors