Filter

Question 1

Function

Answer 1

Description

Question 2

ALL

Answer 2

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

Question 3

ALLCROSSFILTERED

Answer 3

Clear all filters which are applied to a table.

Question 4

ALLEXCEPT

Answer 4

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

Question 5

ALLNOBLANKROW

Answer 5

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.

Question 6

ALLSELECTED

Answer 6

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

Question 7

CALCULATE

Answer 7

Evaluates an expression in a modified filter context.

Question 8

CALCULATETABLE

Answer 8

Evaluates a table expression in a modified filter context.

Question 9

EARLIER

Answer 9

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

Question 10

EARLIEST

Answer 10

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

Question 11

FILTER

Answer 11

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

Question 12

FIRST

Answer 12

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

Question 13

INDEX

Answer 13

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.

Question 14

KEEPFILTERS

Answer 14

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

Question 15

LAST

Answer 15

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

Question 16

LOOKUPVALUE

Answer 16

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

Question 17

MATCHBY

Answer 17

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

Question 18

MOVINGAVERAGE

Answer 18

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

Question 19

NEXT

Answer 19

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

Question 20

OFFSET

Answer 20

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

Question 21

ORDERBY

Answer 21

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

Question 22

PARTITIONBY

Answer 22

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

Question 23

PREVIOUS

Answer 23

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

Question 24

RANGE

Answer 24

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

Question 25

RANK

Answer 25

Returns the ranking of a row within the given interval.