If [# not available] is the empty string you can have a master item have the following set analysis and exclude nulls: =Aggr(Only({<[# not available]={''}>}Products),Products)
That said, what data model do you have that has an aggregatable field that can also result in an empty string? Are you importing it as strings and treating it like a dimension?
