topic Re: Use a IF function on filtered Table in DAX Commands and Tips

Use a IF function on filtered Table

Imad-R — Wed, 04 Jan 2023 15:35:07 GMT

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.

Re: Use a IF function on filtered Table

amitchandak — Wed, 04 Jan 2023 16:33:23 GMT

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

Re: Use a IF function on filtered Table

Anonymous — Thu, 05 Jan 2023 06:25:41 GMT

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