REMOVE

Family: EVAL and its modifiers

The other dimensions of the context stay. Write it inside EVAL.

Syntax

1
EVAL(measure, REMOVE(dimension, ...))

Arguments

Returns

The measure without those dimensions, on each row of the result.

Usage notes

• REMOVE drops the query’s filters on those dimensions too. To keep the filters, use TOTAL with ACROSS, or CALCULATE_ACROSS.
• Write one REMOVE in an EVAL, with every dimension in it. It cannot be mixed with another modifier.
• The measure’s own definition still applies.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.region AS "Region",
3
  orders.channel AS "Channel",
4
  EVAL(orders.sum__quantity) AS "Units",
5
  MEASURE('region_units', EVAL(orders.sum__quantity, REMOVE(orders.channel))) AS "Units on All Channels"
6
FROM kater_dataset.orders AS orders
7
WHERE
8
  KATER__IS_EQUAL_TO(orders.region, 'AMER')
9
GROUP BY
10
  orders.region,
11
  orders.channel
12
ORDER BY
13
  2

Units on All Channels is the units of AMER on every channel. The filter on region stays, because REMOVE names only the channel.

See also

• Change a measure’s context
• Pass through, evaluate or declare
• Other functions in EVAL and its modifiers: EVAL, CLEAR, SET, SET_CUSTOM, CURRENT