Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyCount 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
AllanBercesPost Prodigy
Post ProdigyHi 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
Super User
Super UserHi,
Does this measure work?
Measure = countrows(filter(values(Data[Active]),[Active]="Active"&&([Job %]==0||[Job %]==blank()))