How to check if a value is contained in a filtered column?

[UsePowerBI]

Hello

I want to check if a value is present or not in a filtered column.

How can I do that?

I know the function CONTAINS and I was thinking to use it with the function FILTER but the FILTER function returns a table and not a particular column.

Thanks!

[v-eachen-msft · Accepted solution]

Hi @UsePowerBI ,

You could use CALCULATETABLE() to get filtered column2.

Column =
VAR a =
    CALCULATETABLE (
        DISTINCT ( 'Table'[Column2] ),
        FILTER ( 'Table', 'Table'[Column3] = BLANK () )
    )
RETURN
    'Table'[Column1] IN a

Here is the result.

[amitchandak]

@UsePowerBI ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[UsePowerBI]

@amitchandak 

I have a table with several columns.

I want to check if the value in Col1 exists in a list of values that is comprised of Col2 filtered by some conditions (e.g. when Col3=blank).

Hope this helps.

Thanks!