Trying to fill a blank column with "n/a" or "0"

[U156531]

I'm trying to set a column in a visual to a value to indicate that is not populated. The row uses two tables to poulate the column. In the row for Entrance Sealing the row from the corresponding table does not exist so I end up with blanks. How can I poulate the blanks with "n/a" or "0"? 

Thanks

[U156531]

That worked but I'm trying to take it a step further. I wrote the statement below but I'm getting the error

if ('tbl1'[compatible] = "Y", COALESCE('tbl2'[SumOfUsage],"0"),"Not Compatible")

[lbendlin]

if ('tbl1'[compatible] = "Y", FORMAT(COALESCE('tbl2'[SumOfUsage],0),"#"),"Not Compatible")

[U156531]

I just noticed that I'm having a problem with the new mesaure. When all years are selected from the Bar chart the results in the associated table visual are correct.  But when I select a specific year from the bar chart the results in the table- vusual for the years that weren't selected are still displayed but with incorrect in formation. In the example below 2018 should not be in the table visual and the Estimated Cost should not be N/A. Do you have an idea what I can change to elimante the rows that shouldn't be in the table visual.

[U156531 · Accepted solution]

My user has told me that the Total row is not important. So the only thing I have left is to format the values so that 123456 is formated as 123,456. Can that be done to a field that sometimes contains alpha text?

[lbendlin]

You would need to test if the field contains a number or text and then format the result (in case of number) or use as is.

[U156531]

This working well except the Total line is showing "Not Compatible". Is there a way to get the sum of the rows to show up in the Total line?  

[lbendlin]

if it is a column then you can use COALESCE([Column Name],"n/a")