Forum Discussion

atiftanveer's avatar
atiftanveer
Frequent Visitor
4 years ago
Solved

Second Filter criteria do not work

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( ...
multiple filters
related table
  • atiftanveer's avatar
    atiftanveer
    4 years ago
    tblFilterData = FILTER( 
    CALCULATETABLE (Table_A, RELATEDTABLE(Table_B)),
    AND (not (CONTAINSSTRING(Table_A[Email],"ABC")) ,
    not (CONTAINSSTRING(Table_A[Email],"XYZ") ))
    )
atiftanveer's avatar
atiftanveer
Frequent Visitor
4 years ago
tblFilterData = FILTER( 
CALCULATETABLE (Table_A, RELATEDTABLE(Table_B)),
AND (not (CONTAINSSTRING(Table_A[Email],"ABC")) ,
not (CONTAINSSTRING(Table_A[Email],"XYZ") ))
)