What is going wrong with this "CONTAINS" formula?

[WheelchairWilly]

I need to know what team members in the Bavarian Team picked the correct goal "Scorers" in the goal scorers data. I can spent ages trying to correct the "CONTAINS" formula (The Red Lines etc) I thing that the Relationship between "Picked" and "Scorers" is fine, so why does "Contains" not work?

[v-yanjiang-msft · Accepted solution]

Hi @WheelchairWilly ,

According to your description, here's my solution. 

Create a calculated column in Bavarian table:

Column =
IF (
    CONTAINS ( 'Premiership', Premiership[Goal Scorers], 'Bavarian'[Picked] ),
    "Y"
)

Or this one:

Column1 =
IF (
    'Bavarian'[Picked]
        IN SELECTCOLUMNS ( 'Premiership', "Scorers", 'Premiership'[Goal Scorers] ),
    "Y"
)

All get the correct result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WheelchairWilly]

Hi there and thanks for your help with this matter. I tried your suggestion, unfortunally that disn't workeither. If it all right with you can I pass on the two files I'm trying to get right.

https://we.tl/t-0yiuwzJy9O

[mlsx4]

Hi @WheelchairWilly 

I think you are missing some values. Take a look at the structure: 

CONTAINS(<table>, <columnName>, <value>[, <columnName>, <value>]…)

You need also the second and third part of the IF statement