Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Need Help
Show and Tell

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

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

         

        Regards,

        Harsh Nathani

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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