Forum Discussion

JeanBean's avatar
JeanBean
Frequent Visitor
8 years ago
Solved

Multi WHERE Clause: (OR) AND

Hi,   This a way to apply an OR in the filter conditions? Or adding an embedded where clause?  The tool already applies ANDs between filters but not ORs   EX: (I figured out how to union the two ...
  • JeanBean's avatar
    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)

                                                      ) 

                                             )