Forum Discussion

ss89's avatar
ss89
Helper II
3 years ago

Multiple Filters AND and OR

Hello Community,

 

I have to include another filter in the formula; I have to add 

'TABLE[STAGE_NAME]="SAMPLING",'TABLE[CONDITION]="ONLINE" but The OR function in DAX accepts only two (2) arguments.

 

Could you please help me? 

 

Thanks in advance for your support!

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    ss89 , You can try like

     

    TABLE[STAGE_NAME]="SAMPLING" || 'TABLE[CONDITION]="ONLINE"

     

    or

     

    TABLE[STAGE_NAME] in {"SAMPLING", "ONLINE" }

    • ss89's avatar
      ss89
      Helper II
      3 years ago

      Hi amitchandak ,

      thanks for your prompt reply.

      I have to include at the sime time the three filters (STAGE NAME with his corresponding CONDITION).

      STAGE NAMECONDITION
      SAMPLING

      ONLINE

      SAMPLINGAPPROVED
      RELEASEONLINE