Lookup by filter by column (New calculated column req)

Hi Saxon10 ，

According to you description，you could create columns as follows:

RESULT Id No 200 =
VAR _a =
    SUMMARIZE ( FILTER ( 'DATA', [Id No] = 200 ), [Item] )
RETURN
    IF ( [Item] IN _a, "TRUE", "FLASE" )

RESULT Id No 300 =
VAR _a =
    SUMMARIZE ( FILTER ( 'DATA', [Id No] = 300 ), [Item] )
RETURN
    IF ( [Item] IN _a, "TRUE", "FLASE" )

 Another request:

RESULT1 Id No 200 =
VAR _new =
    SUMMARIZE ( FILTER ( 'DATA', [Id No] = 200 ), [Item] )
RETURN
    IF ( [Item] IN _new, 200 )

RESULT1 Id No 300 =
VAR _new =
    SUMMARIZE ( FILTER ( 'DATA', [Id No] = 300 ), [Item] )
RETURN
    IF ( [Item] IN _new, 300 )

In addition, when [item]=123, Because [Id No] does not contain (200/300), so it may be “False” ?

IF so ,The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.