Forum Discussion
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.
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
2 Replies
- Ahmedx
Super User
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
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
