Solved: Re: COUNT(DISTINCT) in Matrix Visual Power BI

Bambroo69 · ‎07-27-2023

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.

Ahmedx · ‎07-27-2023

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

View solution in original post

Ritaf1983 · ‎07-27-2023

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Ahmedx · ‎07-27-2023

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