If you're just trying to find where error_count is equal to qualify_count and patient_count is greater than 0, this snippet that incorporates somesoni2's comment above should work: | where error_count=qualify_count AND patient_count>0 ... View more