Best way to show zero instead of ' ' (blank)

[Ricardo77]

Hello,

is there any automatic/easy way to [force] show 0 instead of blank in calculations?

i know we can do something like

somecalc=

var insidecalc=1+2x3

return if (isblank(insidecalc); 0; insidecalc)

I also would like to know, generally speaking, why i've seen cases in tables and matrixes where i can see blanks and zeros side to side?

[Greg_Deckler]

@Ricardo77 - I like to use the method you presented. Not sure about the other one, can I see a screen shot?

[amitchandak · Accepted solution]

@Ricardo77 , +0

somecalc= 1+2x3 +0

[Ricardo77]

Jesus 🙂 ,

This this a general solution?

Don't know if i should laugh or cry (for being so simple)

Thanks and Regards

[v-easonf-msft]

Hi , @Ricardo77 

You can  see blanks due  to the empty of the corresponding value . As  mentioned by @amitchandak ,  the best way to  avoid the situation where the empty value shows blank  is to add the value 0 at the end of the formula  . If you think your problem is solved, please mark helpful reply as a  solution or add you own solution  to close this thread.It will better help other community members  find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[Ricardo77]

Hello,

sorry but i would swear i've answered this: the idea of summing zero doesn't work on PBI 64 bits English for RS from January

Also, i've seen in MS pages that we shouldn't force zero to appear, with consequences to performance (as in the way i use, or in divide).

[Greg_Deckler]

@Ricardo77 - There is an option for a column when in a matrix for example to click the drop down arrow and choose "Show items with no data"