Create a new table from existing table with multiple filters

[Anonymous]

Hello, I'm trying to create a new table from an existing table, but on two columns I would like a filter applied:

Column OTIF="Y" and column DG or Config =notblank

I am now using the following formula, but that only includes 1 filter: SELECTCOLUMNS(FILTER('OTIF','OTIF'[Ship set flag]="Y"),"Ship set flag",OTIF[Ship set flag],"Ship set ID",OTIF[Ship set ID],"Order number",OTIF[Order Number],"DG or Config",OTIF[DG or Config])

Thanks for your help!

[Anonymous]

@jdbuchanan71 

I have an almost similar thing, but now instead of a second filter with ISBLANK I need to add 2 filters on the same column, so in total I have 3 filters, is that possible?

FILTER(OTIF,OTIF[Ship set flag]="Y"

FILTER(OTIF,OTIF[Line status]="Awaiting_Supply"

FILTER(OTIF,OTIF[Line status]="Supply_Partial"

Total formula I have now but wasn't working:

Shipset Y&Line status = SELECTCOLUMNS(FILTER(OTIF,OTIF[Ship set flag]="Y") && FILTER(OTIF,OTIF[Line status]="Awaiting_Supply",

"Ship set flag",OTIF[Ship set flag],

"Ship set ID",OTIF[Ship set ID],

"Order line status",OTIF[Line status],

"Order number",OTIF[Order Number]))

[jdbuchanan71]

@Anonymous 

That one you can do using IN.

Shipset Y&Line status =
SELECTCOLUMNS (
    FILTER ( 'OTIF', 'OTIF'[Ship set flag] = "Y" && OTIF[Line status] IN {"Awaiting_Supply", "Supply_Partial"} ),
    "Ship set flag", OTIF[Ship set flag],
    "Ship set ID", OTIF[Ship set ID],
    "Order number", OTIF[Order Number],
    "DG or Config", OTIF[DG or Config]
)

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can apply multiple filters like this.

Table =
SELECTCOLUMNS (
    FILTER ( 'OTIF', 'OTIF'[Ship set flag] = "Y" && NOT ISBLANK ( 'OTIF'[Config] ) ),
    "Ship set flag", OTIF[Ship set flag],
    "Ship set ID", OTIF[Ship set ID],
    "Order number", OTIF[Order Number],
    "DG or Config", OTIF[DG or Config]
)