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

7 Replies

  • 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 ))

  • 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()))