Multiple Filters AND and OR

[ss89]

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!

[amitchandak]

@ss89 , You can try like

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

or

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

[ss89]

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 NAME	CONDITION
SAMPLING	ONLINE
SAMPLING	APPROVED
RELEASE	ONLINE

[amitchandak]

@ss89 , please share the expected output

[ss89]

Hi @amitchandak ,

how can I share the pbix file in the reply?