Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

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

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. 

1 Reply

  • Applicable88 , Try like

     

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