Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DAX Functions > Aggregation > Flashcards

Aggregation Flashcards

1
Q

Function

A

Description

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

APPROXIMATEDISTINCTCOUNT

A

Returns anestimatedcount of unique values in a column.

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

AVERAGE

A

Returns the average (arithmetic mean) of all the numbers in a column.

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

AVERAGEA

A

Returns the average (arithmetic mean) of the values in a column.

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

AVERAGEX

A

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

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

COUNT

A

Counts the number of rows in the specified column that contain non-blank values.

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

COUNTA

A

Counts the number of rows in the specified column that contain non-blank values.

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

COUNTAX

A

Counts non-blank results when evaluating the result of an expression over a table.

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

COUNTBLANK

A

Counts the number of blank cells in a column.

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

COUNTROWS

A

Counts the number of rows in the specified table, or in a table defined by an expression.

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

COUNTX

A

Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table.

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

DISTINCTCOUNT

A

Counts the number of distinct values in a column.

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

DISTINCTCOUNTNOBLANK

A

Counts the number of distinct values in a column.

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

MAX

A

Returns the largest numeric value in a column, or between two scalar expressions.

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

MAXA

A

Returns the largest value in a column.

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

MAXX

A

Evaluates an expression for each row of a table and returns the largest numeric value.

17
Q

MIN

A

Returns the smallest numeric value in a column, or between two scalar expressions.

18
Q

MINA

A

Returns the smallest value in a column, including any logical values and numbers represented as text.

19
Q

MINX

A

Returns the smallest numeric value that results from evaluating an expression for each row of a table.

20
Q

PRODUCT

A

Returns the product of the numbers in a column.

21
Q

PRODUCTX

A

Returns the product of an expression evaluated for each row in a table.

22
Q

SUM

A

Adds all the numbers in a column.

23
Q

SUMX

A

Returns the sum of an expression evaluated for each row in a table.

DAX Functions (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions