Identify users who haven't completed a form

[HMJSomerset]

Hi, 

I have a report that displays the reponses of a simple daily questionnaire that goes to all staff.  I have been asked to report the names of those staff who haven't completed the questionnaire.

I have the responses and I have the list of all staff, how do I count and identify those staff who haven't completed the form?  I am struggling to find the correct DAX expression to use

[HMJSomerset]

Thanks @amitchandak 

I don't think that I explained to problem correctly.  

I have a table with daily questionnaire responses that only contains those staff who have completed the questionnaire.

I have a table drawn from Active Directory that lists all staff.

I want to list all the staff in the AD Staff list that do not appear in the Questionnaire Responses table

How do I record that?  In the example above how do I show that Jeanette hasn't completed the questionnaire?

[amitchandak]

@HMJSomerset , Same stuff

cnt = countrows(filter('questionnaire responses', [Question] ="Yes"))

Not filled = countx(values('Staff list (AD)'[Staff ID]), if(isblank([cnt]) , 1, blank()) )

refer if needed

isblank is not just to check blank values, It can be used to flip the behavior of a measure, which comes handy to solve the problem like customer retention easily: https://www.youtube.com/watch?v=roGE2qrp-eA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=54

[amitchandak · Accepted solution]

@HMJSomerset , Create any measure on the table having form

cnt = countrows(Table)

Not filled = countx(values(Table[Emp]), if(isblank([cnt]) , 1, blank()) )

Use this measure with staff /emp name

[HMJSomerset]

Thank you @amitchandak .  I have tried this and it works.