Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Count Blank and Zero

Hi Good day, Can pls help me on how to total the blank and zero base from active column. from sample below total blank and zero = 8. Thank you
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

AllanBerces , Try below measures

 

Blank count

Countrows(filter(Table, Isblank([Job%]) ) )

 

Zero count
Countrows(filter(Table, not(Isblank([Job%]) ) && [Job%] = 0 ))