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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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.