Calculated column based on presence of one type of value out of many values for one order number

[_JE_]

Long time scroller, first time poster.

I have two tables related by order number.  Table1 orders have no duplicates, and table2 orders have as many duplicates as there are items on the order.  I want to create a calculated column in Table1 that populates a value based on the existence of a certain item in Table2.

In the example below, Calc_Column says Yes if Table2[Order] has Item x. 

Table1                                        Table2
Order Calc_Column             Order     Item
1        Yes                               1          x
2        No                               2          a
3        Yes                               3          b
4        No                               3          x
5        Yes                               3          z
6        No                               4          a
                                              5          a
                                              5          x
                                              6          b

Thanks everyone!

[_JE_]

This worked beautifully.  Thank you.

[jdbuchanan71 · Accepted solution]

@_JE_ 

The calculated column would be like this.

Calc_Column = 
IF (
    ISBLANK ( CALCULATE ( COUNTROWS ( Table2 ), Table2[Item] = "x" ) ),
    "No",
    "Yes"
)