Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Not in List Daily

Hi,  I have two tables, one static table with a list of names and IDs in departments, and another table that is an export of employees filling out a questionaire daily. I was wondering if there...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Anonymous  Al is also in the ch station right so should display too?

     

    Use ALLSELECTED() instead of ALL(): 

     

    MissingForm =
    VAR formcomplete = VALUES(FormSubmissions[Employee ID])
    RETURN
    CONCATENATEX(FILTER(ALLSELECTED(Employees), NOT(Employees[ID] IN formcomplete)), Employees[Name], ", ")
AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Anonymous  Al is also in the ch station right so should display too?

 

Use ALLSELECTED() instead of ALL(): 

 

MissingForm =
VAR formcomplete = VALUES(FormSubmissions[Employee ID])
RETURN
CONCATENATEX(FILTER(ALLSELECTED(Employees), NOT(Employees[ID] IN formcomplete)), Employees[Name], ", ")
Anonymous's avatar
Anonymous
Not applicable
5 years ago

AllisonKennedy Thank you so much for all of your help! I believe this is the solution. I will need to double check hundreds of  names so that should take a while. But so far it looks like your formula worked. Thank you so much again!!
Sarah