Forum Discussion
Solved
Creating a complicated filter using DAX
Good afternoon I have a bit of a complicated filter I'm hoping someone could help me with I have a data set that I'm trying to filter data down to that could be a bit complex, but want to show in a t...
- Meets Criteria = if((not [ID] in {"ABC","123"} || [Name] in {"Test 2","Test 4"}) && not [Name] in {"XYZ","789"},"Yes","No")Note: Your "Test 2" string has an extra space.
lbendlin
Super User
Super UserMeets Criteria = if((not [ID] in {"ABC","123"} || [Name] in {"Test 2","Test 4"}) && not [Name] in {"XYZ","789"},"Yes","No")
Note: Your "Test 2" string has an extra space.
I realized I left a small piece out. The data for "ID" is coming from one table of data while "Name" is coming from another table.
