Relationship Functions
- USERELATIONSHIP(<connection-id>) Specifies an existing relationship to be used in the evaluation of a DAX expression.
Filter Functions
- ALL(<entity-id> [, <field-id>[, <field-id>[,…]]]]) Returns all available rows in a Tab, or for the specified fields.
- FILTER_BETWEEN(<dax-expression>, <field-id>, <start>, <end>) Get all data where the specified numbers or dates are between start and end for the specified field.
- FILTER_COMPARE(<dax-expression>, <field-id>, <operator>, <target>) Get all data where the condition is true.
- FILTER_DATESINPERIOD_COUNT(<dax-expression>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Counts the number of rows in the DAX expression where the specified field has a value within start date and end date.
- FILTER_DATESINPERIOD_DISTINCTCOUNT(<dax-expression>, <field-id (distinct)>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Counts the number of distinct values for the specified field within start date and end date.
- FILTER_DATESINPERIOD_SUM(<dax-expression>, <field-id (to sum)>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Adds all the numbers for the specified field within start date and end date.
- FILTER_DATESINPERIOD_DISTINCTSUM(<dax-expression>, <field-id (distinct)>, <field-id (to sum)>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Adds all the numbers for the specified field for the specified distinct field within start date and end date.
- FILTER_DATESINPERIOD_AVERAGE(<dax-expression>, <field-id (to average)>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Returns the average (arithmetic mean) of all the numbers for the specified field within start date and end date.
- FILTER_DATESINPERIOD_DISTINCTAVERAGE(<dax-expression>, <field-id (distinct)>, <field-id (to average)>, <field-id (date)>, <interval>, <num-intervals>, <start-date>) Returns the average (arithmetic mean) of all the numbers for the specified field for the specified distinct field within start date and end date.
Aggregation Functions
- DISTINCTCOUNT(<dax-expression>, <field-id>) Counts the number of distinct values for the specified field.
- COUNT(<dax-expression>, <field-id>) Counts the number of rows in the DAX expression where the specified field has a value.
- DISTINCTSUM(<dax-expression>, <field-id (distinct)>, <field-id (to sum)>) Adds all the numbers for the specified field for the specified distinct field.
- SUM(<dax-expression>, <field-id>) Adds all the numbers for the specified field.
- DISTINCTAVERAGE(<dax-expression>, <field-id (distinct)>, <field-id (to average)>) Returns the average (arithmetic mean) of all the numbers for the specified field for the specified distinct field.
- AVERAGE(<dax-expression>, <field-id>) Returns the average (arithmetic mean) of all the numbers for the specified field.
Definitions
- dax-expression: One of ALL or USERELATIONSHIP
- operator: One of ==, !=, <>, <=, >=, <, >
- interval: The interval by which to shift the dates—one of DAY, MONTH, QUARTER or YEAR
- num-intervals: An integer that specifies the number of intervals to add to—or subtract from—the dates
- date: One of YYYY-MM-DD or NOW()
- NOW(): Current date and time and can be used with plus and minus for dynamic date and time Example: NOW()+1 means tomorrow if the interval is DAY and next month if the interval is MONTH.
| ID | App | Tab | Field | Kind |
|---|
| ID | Relation | Tab | Field | Relationship | Tab | Field |
|---|