Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a new table from existing table with multiple filters

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 f...
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    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]
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    5 years ago

    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]
)