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( 
CALCULATETABLE    ( Table_A, RELATEDTABLE(Table_B)
), not (CONTAINSSTRING(Table_A[Email],"ABC") &&
not (CONTAINSSTRING(Table_A[Email],"XYZ"))
)
 
Regards
 
Atif
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") ))
    )

1 Reply

  • 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") ))
    )