How to exclude zeros from my column count value?

[dreaves1]

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 my zeros in the count giving it a value of one. Is there something I may be doing wrong? 

[V-lianl-msft · Accepted solution]

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]

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