Create Calculated Column Flagging Same ID from Another Connected Table

[win_anthony]

The goal is to create a calculated column in a table which will flag if a store number is present in another table. Both tables are connected together by the store number. I tried to use the following syntax but it will not work. Any advice on how to achieve the expected output will be greatly appreciated. 

Alerts Table

Store_Number

A1

B1

A2

B2

Shrink Table

Store Number

A1

A2

A3

A4

A5

B1

B2

B3

B4

B5

Expected Output
Shrink Table
Store_Number	Store_Number Match From Alerts Table
A1	YES
A2	YES
A3
A4
A5
B1	YES
B2	YES
B3
B4
B5

IF(
    Shrink[Store Number] = RELATED(Alerts[STORE_NUMBER])
    ,"Yes"
)

[jdbuchanan71 · Accepted solution]

@win_anthony 

Give this a try.  You would add it as a calculated column on your Shrink table.

Store_Number Match From Alerts Table =
IF ( COUNTROWS ( RELATEDTABLE ( Alerts ) ) > 0, "YES" )

[Ashish_Mathur · Accepted solution]

Hi,

Enter this calculated column formula in the Shrink table

=if(shrink[store_number]=lookupvalue(Alerts[Store_number],Alerts[Store_number],shrink[store_number]),"yes",blank())

Hope this helps.

[Anonymous]

The LOOKUPVALUE function will also work great in this situtation. 

[jdbuchanan71 · Accepted solution]

@win_anthony 

Give this a try.  You would add it as a calculated column on your Shrink table.

Store_Number Match From Alerts Table =
IF ( COUNTROWS ( RELATEDTABLE ( Alerts ) ) > 0, "YES" )