List all parts per repair in one column but filter out certain parts from each list?

[sfsamperi13]

Data looks like this:

DispatchID      Commodity

12345              top

12345              case

12345              bottom

12345              side

9876                top

9876                bottom

9876                arm

I want to filter out bottom and side, so that it looks like this:

DispatchID      Commodity

12345              top|case

9876                top|arm

Current formula that is listing all parts (too many):

All Part List =

CONCATENATEX (

FILTER (

SUMMARIZE ( 'FMP Export', 'FMP Export'[DispatchID], 'FMP Export'[Commodity] ),

'FMP Export'[DispatchID] = EARLIER ( 'FMP Export'[DispatchID] )

),

'FMP Export'[Commodity],

"|"

)

[amitchandak]

@sfsamperi13 , Create a measure like

concatenatex ( filter ( 'FMP Export', NOT( 'FMP Export'[Commodity] IN { "bottom", "side" } )),'FMP Export'[Commodity]," | ")

[CNENFRNL · Accepted solution]

@sfsamperi13 , you may try such a measure

All Part List = 
CONCATENATEX (
    FILTER (
        VALUES ( 'FMP Export'[Commodity] ),
        NOT ( 'FMP Export'[Commodity] IN { "bottom", "side" } )
    ),
    'FMP Export'[Commodity],
    " | "
)