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