Forum Discussion

Anonymous

Not applicable

6 years ago

Exclude Zero and blank from Count

My Count Item formula excluding blank but not zero. I want to exclude zero from ITEM COUNT.

Community Support

6 years ago

Hi Anonymous , try measure like this:

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Item]<>0 && 'Table'[Item]<>BLANK())

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Item]<>"0" && 'Table'[Item]<>BLANK() && 'Table'[Item]<>"")

Perhaps need to modify the measure according to the column’s data type.