How to handle numeric null or blank values

[akosiRandy]

I building a visual table where some values on some days has null or blank values. Please advise. Thanks in advance.

Accepted = if(isblank(SUM(Chat_Snowflake[ACCEPTED Original])),0,SUM(Chat_Snowflake[ACCEPTED Original]))

or

Accepted = if(SUM(Chat_Snowflake[ACCEPTED Original]=0,0,SUM(Chat_Snowflake[ACCEPTED Original])

[akosiRandy]

using Accepted = coalesce(sum(Chat_Volume[ACCEPTED Original]),0) works on a table visuals, but not in matrix (see above). thanks.

[kpost · Accepted solution]

what exactly are you trying to do with the blank values?

It looks like maybe you want them to display as zeros?

Accepted = COALESCE(SUM(Chat_Snowflake[ACCEPTED Original]), 0)

//Mediocre Power BI Advice,  but it's free//

[akosiRandy]

@kpost somehow, it works on table visual, but not on matrix visual hmmm