How to create except row value column

[adityavighne]

How to create except row value column?

I have a column with values 

Channel

A

B

C

D

E

F

G

H

I

J

K

L

want to create a new column where I don't want(except) A, C, D, G, H

I need output like - 

Channel

B

E

F

I

J

K

L

[AlB]

Hi @adityavighne 

If you want it in another table, you can create a new calculated table:

NewTable = FILTER(Table1, NOT Table1[Channel] IN { "A", "C", "D", "G", "H"})

or alternatively:

NewTable2 = EXCEPT(ALL(Table1[Channel]),{ "A", "C", "D", "G", "H"})

If you want it in a table visual you can ust use the visual level filters and deselect the letters you don't want shown.  

[adityavighne]

I don't want to create a new table. this is not working.

[PattemManohar]

@adityavighne In that case, just filter the column in "Query Editor"