Calculate No response

[Anonymous]

Dear all,

I want to extract list of employees who dont fill out the response form.

Available data:

1. I have list of total employees.

2. Response from employees who fill on daily basis.

Issue:

Some employees dont fill out response form daily. So, employees who dont fill the form need to be listed in power BI.

Who makes entries via form can be easily extracted, but who dont make entries on response on daily basis couldnt be extracted.

Please help to achieve it

[az38]

Hi @Anonymous 

First, make sure you have relationships between tables

Second, add a measure into Employee table

Measure = 
var _maxDays = CALCULATE(DISTINCTCOUNT(ResponseTable[Date]), ALL(ResponseTable))
RETURN
IF(DISTINCTCOUNT(ResponseTable[Date]) < _maxDays, FALSE(), TRUE())

Third, filter by FALSE() value of new Measure - it will match your demand 

[harshnathani]

Hi @Anonymous ,

If you have the list of ALL Employees in one table.

And responses from form comes in the form a a different table..

You can use the merge option in Power Query to find the list of employees who have not responded.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hii... Thanks!! I tried this, but its showing whole people who doesnt fill.

I am looking for who didnt fill response by each day... I have time stamp in response sheet. Any solution pls?

TIA

[harshnathani]

Hi @Anonymous ,

Can you pls share sample data and how does your data model look like.

Regards,

Harsh Nathani

[Anonymous]

@harshnathani @az38 @amitchandak Please support

Hi...

Below are table 1 Rsponse table and table 2 is employee database. I want to pull out name of employees who didnt fill the response sheet daily.

So, I need daywise employee name who filed to fill. 

If I filter for 22nd in merged sheet, I want Name "P" in non filled and M on 21st.

[amitchandak]

@Anonymous , you can add +0 to the measure and get all the employees

Total Customer = Count(Table[emp])+0

Or you can use this option