filter table in "in" dax formula

[Anonymous]

Hello, 

I am having a problem which seems simple, but I am not finding the solution. I am using this formula to create a column telling me if the values of one column can be found in another table : 

in.AR = if(AllTvLinks[TV Link] in DISTINCT(AsRun[TV Link]);1;0)

But I want to formula to filter the AsRun table. I need to look only for the observations where AsRun[IsCurrent] = 1. I have tried with the "calculate function" but it doesn't work. 

Thanks in advance for any help, 

Have a nice day,

Simon Laurant

[Anonymous · Accepted solution]

HI @Anonymous,

You can also try to use 'countrows' and 'filter' functions to filter other records based on current table values.

Flag =
COUNTROWS (
    FILTER (
        TargetTable,
        TargetTable[TV Link] = CurrentTable[TV Link]
            && TargetTable[IsCurrent] = 1
    )
) > 0

Regards,

Xiaoxin Sheng

[ChrisMendoza]

@Anonymous -

Could you just use LOOKUP like below?