Forum Discussion
Helper IIHow 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 my zeros in the count giving it a value of one. Is there something I may be doing wrong?
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.
2 Replies
- jdbuchanan71
Super User
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
V-lianl-msftCommunity Support
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.
