Use a IF function on filtered Table

Hi  Imad-R ,

I created some data:

Table1：

Table2：

If you want to make IF judgments by columns of two tables, you can use Selectcolumns().

SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn

Custom rule.

First filter the data of Table2 with [Index] <=, after judging whether Table1's [Group] exists after filtering Table2's [Group].

Here are the steps you can follow：

1. Create calculated column.

Column =
var _table1=
FILTER(
    'Table2','Table2'[Index]<=3)
var _column=
SELECTCOLUMNS(_table1,"1",[Group])
return
IF(
    'Table1'[Group] in _column ,1,0)

2. Result:

Best Regards,

Liu Yang

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