DistinctCount shows 1 when it is 0
I have added a Card to my PowerBI report that shows how many distinct customers are matched, per Reason code. I have 8 lines for 4 customers. so with no filters the card shows 4, which is correct. If I filter on Reason=Material, the card shows 3, which is also correct. And when Reason=Process, the card shows one, which is also correct. If I exclude Material and Process from the filter, the card should show 0, but shows 1. Why??? And more importantly, how do I fix it? /*CountOfMatched = DISTINCTCOUNT(Table[Customer])+0*/ CountOfMatched for Reason Material = 3 (correct) CountOfMatched for Process = 1 (correct) CountOfMatched for none of them = 0 but the visual shows 1
