Forum Discussion
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
pls try this
or
7 Replies
AllanBerces , Try below measures
Blank count
Countrows(filter(Table, Isblank([Job%]) ) )
Zero count
Countrows(filter(Table, not(Isblank([Job%]) ) && [Job%] = 0 ))Hi,
Assuming Job % is a measure that you have written, write this measure
Measure = countrows(filter(values(Data[Active]),[Job %]==0||[Job %]==blank()))
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
Hi,
Does this measure work?
Measure = countrows(filter(values(Data[Active]),[Active]="Active"&&([Job %]==0||[Job %]==blank()))
pls try this
or
Hi Ashish_Mathur amitchandak Ahmedx Thank you for the reply you save my day.
You are welcome.
