Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Did you add a +0 to the end of the calcuation for the measure used for the Responses column?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |