Second Filter criteria do not work

[atiftanveer]

Hi,

following DAX expression do not filter rows match second critatia i.e. Table_A[Email] not ContainString "XYZ". I can see rows conting XYZ in table. What's worng!

tblFilterData = FILTER( 

CALCULATETABLE    ( Table_A, RELATEDTABLE(Table_B)

), not (CONTAINSSTRING(Table_A[Email],"ABC") &&

not (CONTAINSSTRING(Table_A[Email],"XYZ"))

)

Regards

Atif

[atiftanveer · Accepted solution]

tblFilterData = FILTER( 

CALCULATETABLE (Table_A, RELATEDTABLE(Table_B)),

AND (not (CONTAINSSTRING(Table_A[Email],"ABC")) ,

not (CONTAINSSTRING(Table_A[Email],"XYZ") ))

)