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) argumen...
Need Help
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
  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    ss89 , please share the expected output

    • ss89's avatar
      ss89
      Helper II
      3 years ago

      Hi amitchandak ,

       

      how can I share the pbix file in the reply?