Getting nulls to show up as zero in Matrix

[brockshagena]

I am working on a project reporting on call center activity data.  The issue I am running into is when displaying Agent call data in a matrix table (or any ohter visual) if the agent made no calls for that day the agent does not show up int the matirx.  The users are accustomed to an excel table where all users are present but display a 0 in the colums  if they did not make any calls. Not sure the best way to achieve this.

Thanks

[Bibiano_Geraldo · Accepted solution]

Hi @brockshagena ,

My sample table look like this:

Our goal its to sum the sales, but even if a day dont have sales, we want to display in the Matrix.

if we use a simple sum like:

Sales Amount = SUM(Sheet1[Sales])

 Our return will ignore days with no sales:

But when we add + 0 at the end of function like bellow DAX, the Matrix will now display all days:

Sales Amount = SUM(Sheet1[Sales]) + 0

you can achieve the same by this DAX:

Sales Amount = COALESCE(SUM(Sheet1[Sales]),0)

Or by showing items with no data:

[brockshagena]

Thank you!  this produced the results I was expecting (used a count() instead of a sum)

[Ashish_Mathur]

Hi,

Try this measure

Measure = coalesce([your measure],0)

Hope this helps.

[Sahir_Maharaj]

Hello @brockshagena,

Can you please try the following approach:

Lets use this as a sample (Ensuring your tables have the necessary relationships)

Agent Name    Agent ID
John Doe      101
Jane Smith    102
Alex Brown    103

You can create a measure that counts calls and replaces nulls with zeros.

CallCount = 
VAR CallCountValue = SUM(CallActivityTable[CallCount])
RETURN
    IF(ISBLANK(CallCountValue), 0, CallCountValue)

Hope this helps.