I'm trying to create an aggregate calculated field that counts the distinct members in a dimension field and when there are no IDs equals zero. For example, in the attached, with no filtering on any of the dimensions countd() equals 11. I want to make a descriptive label in a dashboard so I've added some text to say "11 distinct IDs". Everything works fine, except when all rows are filtered out. In this case I want the label to say "0 distinct IDs".
I've tried a few ways but can't figure out how to get what I want.