Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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() )
@tex628 Hi,
I dont need date column. Only customer Key, Name and the measure. For those customers below it must return true
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() )