Forum Discussion

Bambroo69's avatar
Bambroo69
Frequent Visitor
3 years ago
Solved

COUNT(DISTINCT) in Matrix Visual Power BI

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. 
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

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