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_S...
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.