Calculatetable filter value depending on two columns, which has subset with others

[Applicable88]

Hello,

I have a raw table which I want to calculate a filtered table:

Category		TYP
111		A
111		C
111		D
111		E
222		A
222		C
333		C
333		A

I just want to get rid of all 222 Categories, but only those of type C. 

I'm not getting the expected outcome with this one, since it will get rid of all 222 and all C: 

Temorarytable = Calculatetable ( Table , Table [Categories ]<> "222" && Table [Type] <> C))

I have several things to filter from that table, so I chose Calculatetable. But I stuck with this conditions, since I want to keep the 222, but only those without Type C. At the same time also keep other Type C with other category. 

Thank you very much in advance. 

Best. 

[amitchandak · Accepted solution]

@Applicable88 , Try like

Table = CALCULATETABLE(Data, filter(Data,not( Data[Category ] = 222 || Data[TYP] ="C")))