Forum Discussion

Viswa1127's avatar
Viswa1127
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 val...
Need Help
Show and Tell
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Viswa1127 ,

     

    Try using either of these:

    _option1 = DISTINCTCOUNTNOBLANK(yourTable[yourColumn])

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

     

    Pete

BA_Pete's avatar
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's avatar
    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.