IGNORE_FILTERS

Family: Calculation context

The grouping does not change.

Syntax

1
TOTAL(measure, BY(...), IGNORE_FILTERS(dimension, ...))

Arguments

Returns

Nothing of its own. It changes the filters of the call that holds it.

Usage notes

• The measure’s own definition and the filters of the models it reads still apply.
• The compile refuses a filter that it cannot separate from the dimension, and two changes to the same dimension in one call.

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
  EVAL(orders.sum__quantity) AS "Web and Email Units",
4
  MEASURE('all_channel_units', TOTAL(orders.sum__quantity, BY(orders.region), IGNORE_FILTERS(orders.channel))) AS "Units on All Channels"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_ONE_OF(orders.channel, 'web', 'email')
8
GROUP BY
9
  orders.region
10
ORDER BY
11
  1

The query keeps only web and email orders. Units on All Channels ignores that filter, so it counts every channel in each region.

See also

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