Use conditional logic based on a list of values filtered from a column in a related table...

[Debo1996]

Hi, 

So I have two tables voucher table (contains a list of all vouchers with voucher number as the primary key) and item table (contains a list of items in each voucher, so multiple enteries for same voucher possible).

  

Now I need a DAX formula which can help me fill the column Does this voucher contain banana? (return "banana" if yes or else "no"). 

I am struggling with returing a list of item names that correspond to a particular voucher and then perform an operation on it.

Thanks!

[amitchandak · Accepted solution]

@Debo1996 ,

A new column in the voucher

flag =

var _cnt = countx(filter(item, item[Voucher number] = Voucher[Voucher number] &&[Item] = "Banana"),item [Item])

return

if(isblank(_cnt), "No", "Banana")