Replace 0 with N/A in chart

[Taylorcc]

Hello, 

I have created the measure - sum(if (([Principal Focus]='Clinical Care'), [Episode Target]))

Is it possible for the answer to display 'N/A' if the calculation returns 0, rather than the 0? 

Thank you!

[Ivan_Bozov · Accepted solution]

Hi, try this:

IF(SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target])>0, SUM({<[Principal Focus]={'Clinical Care'}>}[Episode Target]), 'N/A')

[Taylorcc]

This works perfectly! Thank you