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

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
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