Contains

[Fcoatis]

Hello,

I need to create a measure to check values against a virtual table like this:

Test = 
VAR currCustomer = VALUES(Customer[CustomerKey])
VAR TempTable = FILTER(InternetSales,InternetSales[OrderDate]<DATE(2011,1,1))
RETURN
IF(
    HASONEFILTER(InternetSales[CustomerKey]),
    CONTAINS(TempTable,Customer[CustomerKey],currCustomer),
    BLANK()
)

But every record returns false. What am I doing wrong? Sample is Here

Thanks in advance

[tex628]

Is this the desired result? 

[Fcoatis]

@tex628 Hi,

I dont need date column. Only customer Key, Name and the measure. For those customers below it must return true

[tex628 · Accepted solution]

Just replace ur measure with this;

Test = 
VAR currCustomer = SELECTEDVALUE(Customer[CustomerKey])
VAR TempTable = FILTER(InternetSales,InternetSales[OrderDate]<DATE(2011,1,1))
RETURN
IF(
    CONTAINS(TempTable,Customer[CustomerKey],currCustomer),
    TRUE(),
    FALSE()
)

[Fcoatis]

@tex628 Thank you very much!