Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Bambroo69
Frequent Visitor

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. 

1 ACCEPTED SOLUTION
Ahmedx
Super User
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

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

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.

 

Ritaf1983_0-1690512426161.png

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

Ahmedx
Super User
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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.