Show 0 instead of blank for completion rate

[TomLU123]

Dear experts,

I am using measures to get the completion rate of a satisfaction survey. Some locations (title in the table) got no responses, and the completion rate shows blank. Is iit possible to show 0 in both "Responses" and "Completion Rate" instead of blank?

Here are the formulars I am using:

Total Number of Responses = COUNT('Overall Result'[Response ID]) 

Total Number of Hiring Managers = COUNT('Hiring Manager List'[Hiring Manager Name])

Completion Rate = [Total Number of Responses]/[Total Number of Hiring Managers]

Many thanks!

Best regards,

Tom

[Phil_Seamark]

Hi @TomLU123

An easy thing to try that works in some scenarios is to just add a +0 to the end of the calculation

eg..

COUNT('Overall Result'[Response ID])  +0

[TomLU123]

Hi Phil, @Phil_Seamark

Yes, it works! Thank you so much!

I have changed the fomular to COUNT('Overall Result'[Response ID]) +0

Just another question, how can we show 0 instead blank in the "Responses" column?

Many thanks!

Best regards,

Tom

[Phil_Seamark]

Did you add a +0 to the end of the calcuation for the measure used for the Responses column?

[TomLU123]

Hi Phil, @Phil_Seamark

Yes, the current formulars are like this:

Total Number of Responses = COUNT('Overall Result'[Response ID])+0

Total Number of Hiring Managers = COUNT('Hiring Manager List'[Hiring Manager ID])

Completion Rate = [Total Number of Responses]/[Total Number of Hiring Managers]

Is it because the setting of the visualization?

Many thanks!

Best regards,

Tom

[Phil_Seamark]

Hi @TomLU123

It can be more complex than that.  Sometimes, if you simply have no data for an intersecting combination of fields, the calculation simply won't even run, so there is nothing for you to add the +0 trick to.

Although it should be ok with the COUNTROWS function.  I notice your calculations are using data from multiple tables.  I would be helpful to understand more about your data model to provide a better suggestion.