Forum Discussion
Multi WHERE Clause: (OR) AND
- 8 years ago
Ok, I think I figured it out. I have to use a combination of UNION, FILTER, SEACH, ||
I used the || as a logical OR, and applied the final AND on the Report Filter section
Merge_Table = UNION (FILTER ('Table A'
SEARCH("America",Table A[region], 1, 0) ||
SEARCH("Europe",Table A[region], 1, 0) ||
SEARCH("testing",Table A[team], 1, 0)
) ,
FILTER ('Table B'
SEARCH("AM",Table A[region], 1, 0) ||
SEARCH("EU",Table A[region], 1, 0) ||
SEARCH("TEST",Table A[team], 1, 0)
)
)
Ok, I think I figured it out. I have to use a combination of UNION, FILTER, SEACH, ||
I used the || as a logical OR, and applied the final AND on the Report Filter section
Merge_Table = UNION (FILTER ('Table A'
SEARCH("America",Table A[region], 1, 0) ||
SEARCH("Europe",Table A[region], 1, 0) ||
SEARCH("testing",Table A[team], 1, 0)
) ,
FILTER ('Table B'
SEARCH("AM",Table A[region], 1, 0) ||
SEARCH("EU",Table A[region], 1, 0) ||
SEARCH("TEST",Table A[team], 1, 0)
)
)