Use a IF function on filtered Table

[Imad-R]

Hello everyone,

I want to make a conditional calcul between 2 table the second table must be previously filtered with FILTER  function.

The table must be filter with a SELECTEDVALUE function.

Someone can help me please.

[v-yangliu-msft · Accepted solution]

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

[amitchandak]

@Imad-R , You can not use selectedvalue in the calculated table or column.

That can only be used in measure or a table in the var of measure