List of rows not appearing in another

[Dark_crab]

I have 2 files

1. List of all students

2. List of all students activities (with dates)

How can I get a list of students, who didn't participate at any activities in a given time period?

Thanks

[Dark_crab]

Thank you. It worked and now i understand the logic behind it)

[amitchandak · Accepted solution]

@Dark_crab , assume table 1 (list of student) is having 1 to Many join with table2.

Then create a measure like

_cnt = count(Table2[Student])

Student do not have any activity

countx(values(Table[Student]), if(isblank(_cnt) , [Student], blank())