I have a measure which would turn the correct results based on an "is not null".
Works in a named query but it also filters out the rest of the columns.
I noticed when I look in properties on a measure the first line designates null values. However, it doesn't allow for change. Something like this would work great.