How filter enumlist

[167]

I am still confuse about comparing the value

I have 2 table

• student list
  

  

• class list (students who previously attended the class)
  

When I want to start a makeup class,
I trying to get the enumlist to show only student who have contact detail and never attend this lesson before

I stuck …

SELECT(Student_list[Students],
AND([Contact] = “Yes”, …

[Suvrutt_Gurjar]

Please try

SELECT(Student_list[Students], [Contact] = “Yes”) - SPLIT(class_list[Students] , " , ")

[167]

@Suvrutt_Gurjar

it show all the student in the student list (including those attended before)

[Suvrutt_Gurjar]

Please share the screenshot of expression and the associated test result from test pane.

Also please try

SELECT(Student_list[Students], [Contact] = “Yes”) - SPLIT(UNIQUE(class_list[Students]) , " , ")

[Suvrutt_Gurjar]

Also there are some students like A3, A7 who are with [Contact] as “No” in “Student_list” but still apears in Class list in [Student] enumlist in the example shown by you. Please elaborate exact condition you are trying to achieve.

[167]

@Suvrutt_Gurjar

Sorry for the wrong example, the image was I try to do recording without using formula. That’s why there are error that make me want to use formula to avoid.

What I mean was,
There are 20 students

lets say 7 of them attended my Math class.

The next time I want to start a make up class for the same Math class again, I will only able to pick from the 13 who have contact in the record.

[Suvrutt_Gurjar]

167:

There are 20 students

Thank you for the corrections. Could you also update if you want to still check the [Contact] status also for the [Student] from Student_list table?

[167]

Example

Students_list

Class_list

I want to achieve, when I choose Math again, the enumlist should not be showing those attended Math before

Student should not appear : A1 , A4 , A5 , A6 , A12 , A13 , A14

[Suvrutt_Gurjar · Accepted solution]

Thank you. Please try

SELECT(Student_list[Students], [Contact] = “Yes”) - SPLIT(SELECT(class_list[Students], [Class]=[_THISROW].[Class]) , “,”)

**Edit:**Corrected the error in expression.

[167]

Suvrutt_Gurjar:

SELECT(Student_list[Students], [Contact] = “Yes”) - SPLIT(SELECT(class_list[Students], [Class][_THISROW].[Class]) , “,”)

[Suvrutt_Gurjar]

Sorry. There was a minor error of missing equality operator in the expression. I have corrected it. Please try the revised expression in the earlier post.

[167]

@Suvrutt_Gurjar

COOL !!!
U save my day … Thanks !!!