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.

Super User

6 years ago

Anonymous , Try measure like

countrows(filter(table, not(isblank(Table[Item])) && Table[Item] <> 0 ))

or
countrows(filter(table, coalesce(Table[Item],0) <> 0 ))