To explain the requirement again. I need to find the distinct count of TaskName which have their entire UserEnabled as the following combinations:
TaskName, User, UserEnabled A, 1, False A, 2, False B, 3, False B, 4, Null (Not text value. This is actual NULL) C, 5, Null So the distinct count of the TaskName will be 2 (TaskName: A,B,C will be counted).
So I want TaskNames which have all their users as False or NULL(Not text value but actual NULL).