Thank you for the response but that will not work since '0' will be charted.
This is why I am using #NA for the case were I need the row filtered out.

I can get it to work manually the way I want by Reapplying the Filter each time after a change is made. The issues is that this is supposed to be a 'no touch' sheet and I would like the filter to apply automatically every time there is a change or the sheet is activated.