Forum Discussion
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.
Applicable88 , Try like
Table = CALCULATETABLE(Data, filter(Data,not( Data[Category ] = 222 || Data[TYP] ="C")))
1 Reply
- amitchandak
Super User
Applicable88 , Try like
Table = CALCULATETABLE(Data, filter(Data,not( Data[Category ] = 222 || Data[TYP] ="C")))