Filter Flashcards

1
Q

Function

A

Description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ALL

A

Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ALLCROSSFILTERED

A

Clear all filters which are applied to a table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ALLEXCEPT

A

Removes all context filters in the table except filters that have been applied to the specified columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ALLNOBLANKROW

A

From the parent table of a relationship, returns all rows but the blank row, or all distinct values of a column but the blank row, and disregards any context filters that might exist.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ALLSELECTED

A

Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

CALCULATE

A

Evaluates an expression in a modified filter context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

CALCULATETABLE

A

Evaluates a table expression in a modified filter context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

EARLIER

A

Returns the current value of the specified column in an outer evaluation pass of the mentioned column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

EARLIEST

A

Returns the current value of the specified column in an outer evaluation pass of the specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

FILTER

A

Returns a table that represents a subset of another table or expression.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

FIRST

A

Used in visual calculations only. Retrieves a value in the visual matrix from the first row of an axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

INDEX

A

Returns a row at an absolute position, specified by the position parameter, within the specified partition, sorted by the specified order or on the specified axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

KEEPFILTERS

A

Modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

LAST

A

Used in visual calculations only. Retrieves a value in the visual matrix from the last row of an axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

LOOKUPVALUE

A

Returns the value for the row that meets all criteria specified by search conditions. The function can apply one or more search conditions.

17
Q

MATCHBY

A

In window functions, defines the columns that are used to determine how to match data and identify thecurrent row.

18
Q

MOVINGAVERAGE

A

Returns a moving average calculated along the given axis of the visual calculation data grid.

19
Q

NEXT

A

Used in visual calculations only. Retrieves a value in the next row of an axis in the visual matrix.

20
Q

OFFSET

A

Returns a single row that is positioned either before or after thecurrent rowwithin the same table, by a given offset.

21
Q

ORDERBY

A

Defines the columns that determine the sort order within each of a window function’s partitions.

22
Q

PARTITIONBY

A

Defines the columns that are used to partition a window function’s parameter.

23
Q

PREVIOUS

A

Used in visual calculations only. Retrieves a value in the previous row of an axis in the visual matrix.

24
Q

RANGE

A

Returns an interval of rows within the given axis, relative to the current row. A shortcut for WINDOW.

25
Q

RANK

A

Returns the ranking of a row within the given interval.