Conditional Column based on link between another table

[Kurt4597]

Hello PowerBI Community, I am stuck on a problem and would be very greatful if somebody could assist me.

Table 1 - Customer List

Table 2 - Order

These tables have a Many to 1 link on CustomerID. So a customer can have multiple orders

I am trying to create a conditional column in the customer list table to determine if the orders created could meet a certain criteria. For example 

If this one of the orders from a customer contains Apple OR If a Large Fruit then TRUE, ELSE FALSE. The end result would be an additional column on the customer list table containing true / false values.

Any help would be massively appreciated!

[amitchandak · Accepted solution]

@Kurt4597 ,

a new column in customer

new column =

var _cnt = countx(filter(order, order[customerid] = customer [customerid] && ( [Fruit] ="Apple" || [Size] ="Large") ) , order[CustomerID])

return

if(isblank(_cnt), false(), True())

[Kurt4597]

Thank you for the help,

Do you know how I can solve it now for three tables? For example I have added a 3rd table

This is connected to the ORDERS table with a many to one relationship. So now we have this

So now if I wanted to create the SAME column as before, except now with an added condition

If this one of the orders from a customer contains Apple OR If a Large Fruit OR if they have an order price over £2 then TRUE, ELSE FALSE. The end result would be an additional column on the customer list table containing true / false values.

Thank you Amitchandak!