cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PatrickByGecko
Resolver I
Resolver I

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

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.

 

Sans titre-3.jpg

Sans titre-4.jpg

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

HusnaBanu413
Memorable Member
Memorable Member

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])))

Blankfillwithzero.PNG

Please do let me know if this helped you

 

 

 

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).Sans titre-3.jpg

 

Sans titre-4.jpg

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors
Top Kudoed Authors