Not sure if this is possible in Power BI, I have a table with Dish and Ingredients. I want to create a filter on what ingredients are available so that I can then make the Dish.
If I filter on [Flour] I want to only see [Apple Pie] and [Pizza]. If I filter on [Tomato Sauce] I want to see [Pasta] and [Pizza].