Forum Discussion

dreaves1's avatar
dreaves1
Icon for Helper II rankHelper II
6 years ago
Solved

How to exclude zeros from my column count value?

Hi,    I've created a conditional column that is a whole number data type and includes zeros. For some reason when I add the count of the column to the Value field of my visualization, it includes ...
General Comment
Need Help
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi dreaves1 ,

     

    You can also try to create a measure.

    Measure = CALCULATE(COUNT('Table'[custom]),FILTER('Table','Table'[custom]=1))

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Change the Count to Sum and you should get the right number.  Counting a row with a 0 still counts the row.  How may rows in this list:

0

1

0

1

Answer: 4