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