cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Calculate No response

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

6 REPLIES 6
Highlighted
Super User IX
Super User IX

Re: Calculate No response

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

 

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

Or you can use this option

ShowItemwithoutdata.JPG



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User V
Super User V

Re: Calculate No response

Hi @bhuvanasundar ,

 

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.

 

1.jpg

 

 

Regards,
Harsh Nathani

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

Highlighted
Super User VI
Super User VI

Re: Calculate No response

Hi @bhuvanasundar 

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 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Highlighted
Helper I
Helper I

Re: Calculate No response

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

Highlighted
Super User V
Super User V

Re: Calculate No response

Hi @bhuvanasundar ,

 

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

 

Regards,

Harsh Nathani

Highlighted
Helper I
Helper I

Re: Calculate No response

@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.table.jpg

 

 

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.