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  I'm not sure what you mean by 'but in table form'. I have created a measure as they are more dynamic and efficient, but please let me know if that doesn't work: 

 

MissingForm =
VAR formcomplete = VALUES(FormSubmissions[Employee ID])
RETURN
CONCATENATEX(FILTER(ALL(Employees), NOT(Employees[ID] IN formcomplete)), Employees[Name], ", ")
 
You can see the result in the attached file below signature.
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  thank you!

I have another question.. Below is an additional name and column in your attached file for the "Employees" table. I added "Sarah" and a "Station" column... 

 

ID Name Station
1 Al ch
2 Bob nw
3 Charlie se
4 Dave sc
5 Sarah ch

 


In your FormSubmission table, Al who is from CH station, filled out the form on Dec 1 and Dec 2. Sarah is also from CH station, but did not fill out the form at all on any days. 

How do I show Sarahs name for all days, but also just Sarahs name when i click the CH filter above the table in the screenshot? 
please let me know if my question is confusing

 

Thank you!
Sarah

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    sorry forgot to add the screenshot AllisonKennedy