Count values in a column

[Viswa1127]

Hi All,

I am trying to count the values in one column in my table but it is counting blank values also. How to neglect blank values. Any ideas?

When i apply count it is counting blank values also. Thanks in advance!

[BA_Pete · Accepted solution]

Hi @Viswa1127 ,

Try using either of these:

_option1 = DISTINCTCOUNTNOBLANK(yourTable[yourColumn])

_option2 = COUNT(yourTable[yourColumn]) - COUNTBLANK(yourTable[yourColumn])

Pete

[Viswa1127]

@BA_Pete ,
Thanks alot first one I have tried. I am not aware of countblank() function it is solving my problem.

[Viswa1127]

Hi, How it is help in my current scenario? I just want the count of values in column whithout including the blanks!

[Burningsuit]

Hi @Viswa1127 

You need to understand how the DAX language works with blanks and Zeros, luckily, we've written a blog on exactly that subject.

This should answer your questions.

How DAX Treats Nulls & Zeros | Power BI Guide | Burningsuit

hope this helps

Stuart