How to have Zero if Null in a simple addition of columns

[PatrickByGecko]

Hello

I'm looking for a solution to get zero by default in the columns underneath when the adddition is = zero.  Because the lack of numbers cut the lines of some graphics (see underneath). Thank you for your help.

[v-shex-msft · Accepted solution]

HI @PatrickByGecko ,

You can add '+0' to you formula to replace blank result to zero:

CDI =
Table[CDI AIX-] + Table[CDI NIORT-] + Table[CDI PARIS-]+0

BTW, zero value also not display on charts, they will be filtered by visual itself.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi PatrickByGecko,

You can use the below measure to get zero wherever blank

CDI = if(calculate(sumx(Sumtable,Sumtable[price1]+Sumtable[price2]+Sumtable[price3]))=BLANK(),0,calculate(sumx(Sumtable,Sumtable[price1]+Sumtable[price2]+Sumtable[price3])))

Please do let me know if this helped you

[PatrickByGecko]

It is a good idea. But I have just a problem with a circular reference between CDI DEPART and TURNOVER (I don't understand i see no relation betwen them).