Forum Discussion

Frequent Visitor

4 years ago

Solved

Count values in a column

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!

Try using either of these:

_option1 = DISTINCTCOUNTNOBLANK(yourTable[yourColumn])

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

Pete

Burningsuit
Resident Rockstar
4 years ago
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
Viswa1127
Frequent Visitor
4 years ago
Hi, How it is help in my current scenario? I just want the count of values in column whithout including the blanks!
BA_Pete
Super User
4 years ago
Hi Viswa1127 ,

Try using either of these:

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

Pete
- Viswa1127
  Frequent Visitor
  4 years ago
  BA_Pete ,
  Thanks alot first one I have tried. I am not aware of countblank() function it is solving my problem.