How to exclude a selection in the data set expression?

[user467341]

I have a straight table with n data as columns.

One of the data is called [System_Type]. [System_Type] has the following:

System A INSTALL

System A REMOVAL

System B INSTALL

System B REMOVAL

New System

Old System

REMOVAL System

In the set expression for this data, it is currently =[System_Type].

How can I explicitly exclude selection that has "REMOVAL"? That is, the straight table should not have "REMOVAL" available to the user to select at the column magnifying glass.

I saw some forum posts using E, but I can't get it to work. I know how to filter the selection (but NOT EXCLUDE) if I use Aggr+Only, so what is the reverse to apply EXCLUDE instead?

Thanks.

[BrunPierre · Accepted solution]

Hi

You can use the implicit exclusion operator or the element function E() as such.

=Sum({<[System_Type]-={"*REMOVAL*"}>} Amount)

Or

=Sum({1<[Unique Field]=E({<[System_Type]={"*REMOVAL*"}>} [Unique Field])>} Amount)