Help with filtering unrelated tables

[CowsHateMilk]

Hi there,

I have two tables that share the same universe of data (eg. all fruits) but are otherwise unrelated in the model.

One of the tables associates a person's preferred fruit:

PersonA	Apple
PersonA	Orange
PersonA	Pineapple
PersonB	Apple
PersonB	Pear

And another shows which fruits show up in a specific recipe:

Strawbery Shortcake	Strawberry
Caramelized Apples	Apple
Fruit Salad	Apple
Fruit Salad	Melon
Fruit Salad	Orange

I want to show in a bar chart, given a specific person, how often their favourite fruit shows up in a recipe. For example, I want to be able to filter for PersonA, and have this chart show [Apple, Orange, Pineapple] in the X-axis, and [2,1,0] show up in the Y-axis respectively.

I'm having trouble figuring out how to do this. Open to any suggestions!

Thank you!

[CowsHateMilk]

I can't believe I didnt think of this. Thank you! I also hadn't heard of Coalesce before so very helpful

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attahced.

Hope this helps.