COUNT(DISTINCT) in Matrix Visual Power BI

[Bambroo69]

Does COUNT(DISTINCT) in Matrix Visual ignore null values? I just found out that it counts Null values as 1. Just want to confirm again. 

[Ritaf1983]

Hi @Bambroo69 

If I understood you correctly, you are talking about aggregation (not measure), the answer is yes.

Blanks are a kind of value.

Please see attached picture.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ahmedx · Accepted solution]

Yes that's right.
if you need not to count them, then you need to first filter the table ( FLTER( AL('table','table[sales]<> 0) and then count the number