Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation 
DAX query
Returns a table with information about each KPI in the semantic model. This function provides metadata about Key Performance Indicators defined in the model.
Syntax
INFO.KPIS ( [<Restriction name>, <Restriction value>], ... )
Parameters
Parameters are optional for this DAX function. When parameters are used, both must be given. More than one pair of parameters is allowed. The restriction name and value are text and entered in double-quotes.
| Term | Definition |
|---|---|
| Restriction name | Name of the restriction used to filter the results. |
| Restriction value | Value used to filter the results of the restriction. |
Restrictions
Typically, all columns of the DAX function results can be used as a restriction. Additional restrictions may also be allowed.
Return value
A table with the following columns:
| Column | Description |
|---|---|
| [ID] | Unique identifier for the KPI |
| [MeasureID] | Identifier of the measure associated with the KPI |
| [Description] | Description of the KPI |
| [TargetDescription] | Description of the KPI target |
| [TargetExpression] | DAX expression defining the KPI target value |
| [TargetFormatString] | Format string for displaying the target value |
| [StatusGraphic] | Graphic used to display the KPI status |
| [StatusDescription] | Description of the KPI status |
| [StatusExpression] | DAX expression defining the KPI status |
| [TrendGraphic] | Graphic used to display the KPI trend |
| [TrendDescription] | Description of the KPI trend |
| [TrendExpression] | DAX expression defining the KPI trend |
| [ModifiedTime] | Timestamp of when the KPI was last modified |
Remarks
- Typically used in DAX queries to inspect and document model metadata.
- Permissions required depend on the host. Querying full metadata may require model admin permissions.
Example
The following DAX query can be run in DAX query view:
EVALUATE
INFO.KPIS()
Example 2 - DAX query with joins
The following DAX query can be run in DAX query view:
EVALUATE
VAR _KPIs =
SELECTCOLUMNS(
INFO.KPIS(),
"KPIID", [ID],
"MeasureID", [MeasureID],
"KPI Description", [Description],
"TargetExpression", [TargetExpression]
)
VAR _Measures =
SELECTCOLUMNS(
INFO.MEASURES(),
"MeasureID", [ID],
"Measure Name", [Name]
)
VAR _CombinedTable =
NATURALLEFTOUTERJOIN(
_KPIs,
_Measures
)
RETURN
SELECTCOLUMNS(
_CombinedTable,
"Measure Name", [Measure Name],
"KPI Description", [KPI Description],
"Target Expression", [TargetExpression]
)
ORDER BY [Measure Name]