Filter by values in different rows

Hi, I have a problem with filtering in such a scenario:   I have materials to be produced. Each material has its own MaterialID. Production of a material requires at least one recipe. Each recipe ...