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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Assuming Job % is a measure that you have written, write this measure

Measure = countrows(filter(values(Data[Active]),[Job %]==0||[Job %]==blank()))

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

Hi amitchandak Ashish_Mathur thank you for your reply, for clarification the active column also have IN ACTIVE value, and for the Job % is from calculated column.

Thank you

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Does this measure work?

    Measure = countrows(filter(values(Data[Active]),[Active]="Active"&&([Job %]==0||[Job %]==blank()))