How to check if value isn't present

[AleksanderPunt]

My table contains 20.000 names, where each name have several registrations based on which fruits they ate. So the table has 50.000-60.000 lines of data. I want to find out who did NOT eat a specific fruit? This is just a mockup to showcase the basic problem of my real table, which isn't about fruits 🙂

Is there a formula to retrieve the names of those who didn't eat an orange?

Name	Fruit
John	Banana
John	Orange
Adam	Apple
Adam	Banana
Adam	Orange
Lisa	Apple
Chris	Banana
Chris	Apple

[AleksanderPunt]

Thanks, it looks like the solution from @Fowmy does the trick. Your approach @Anonymousis unfortunately out of my knowledge on how to achieve - I haven't used expressions editors, DAX Query's etc.. but thanks anyway! 🙂

[Anonymous]

I recommend you to create a Name table and a Fruit Table not to fall (ever) in auto-exist. 

Here my approach (very similar to Fowmy's)

[Fowmy · Accepted solution]

@AleksanderPunt 

Create this measure and assign it to the visual filter and set it equal to zero.

Measure = INT(MAX(Table2[Name]) in CALCULATETABLE( VALUES(Table2[Name]) , Table2[Fruit] = "Orange"))