Error message not showing in chart?

[#1]

Hi,

Acn anyone let me know why the message is not showing. I don't want to supress zero values or supress missing values.

I would need to show if there are no values it should populate as 'No fail'

Dimension: Error Code

Expression : If(Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID))=0,'No Fail',
                      Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID)))

Thanks.

[#2]

Thanks. Perfect

[#3]

Is there any way to show only fail text instead of all?