Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Second Filter criteria do not work
06-22-2022
06:41 AM
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
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2022
09:10 AM
tblFilterData = FILTER(
CALCULATETABLE (Table_A, RELATEDTABLE(Table_B)),
AND (not (CONTAINSSTRING(Table_A[Email],"ABC")) ,
not (CONTAINSSTRING(Table_A[Email],"XYZ") ))
)
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2022
09:10 AM
tblFilterData = FILTER(
CALCULATETABLE (Table_A, RELATEDTABLE(Table_B)),
AND (not (CONTAINSSTRING(Table_A[Email],"ABC")) ,
not (CONTAINSSTRING(Table_A[Email],"XYZ") ))
)
Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-26-2023 10:42 PM | |||
Anonymous
| 03-19-2023 12:17 AM | ||
03-21-2023 02:24 PM | |||
05-25-2024 10:07 PM | |||
08-14-2024 08:11 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
21 | |
17 | |
16 | |
7 | |
5 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
29 | |
28 | |
20 | |
13 | |
12 |