CALCULATE_ACROSS

Family: Calculation context

For a measure, TOTAL with ACROSS gives the same value.

Syntax

1
CALCULATE_ACROSS(measure, dimension, ...)

Arguments

Returns

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

Usage notes

• The query’s filters stay, those on the removed dimensions included. To drop them as well, use EVAL with REMOVE.
• KATER__IGNORE_GROUPING_BY writes EVAL with REMOVE, not CALCULATE_ACROSS, so it drops those filters.

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', CALCULATE_ACROSS(orders.sum__quantity, 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

See also

• Change a measure’s context
• Other functions in Calculation context: TOTAL, SHARE_OF_TOTAL, VALUE_FOR, CALCULATE_BY, CALCULATE_PER, RATIO, RUNNING_TOTAL, MOVING_AVERAGE, CUMULATIVE_SHARE, BY, ACROSS, IGNORE_FILTERS