Forum Discussion
Solved
How to handle numeric null or blank values
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])
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//
3 Replies
kpostSolution Sage
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//using Accepted = coalesce(sum(Chat_Volume[ACCEPTED Original]),0) works on a table visuals, but not in matrix (see above). thanks.
