INFO.KPIS DAX Function (Information)
Returns a list of all KPIS in the current model with columns matching the schema rowset for KPI objects.
Syntax
Parameter | Attributes | Description |
---|---|---|
RestrictionName | Optional Repeatable |
Restriction name. |
RestrictionValue | Optional Repeatable |
Restriction value. |
Return values
Field | Type |
---|---|
ID | Integer |
MeasureID | Integer |
Description | String |
TargetDescription | String |
TargetExpression | String |
TargetFormatString | String |
StatusGraphic | String |
StatusDescription | String |
StatusExpression | String |
TrendGraphic | String |
TrendDescription | String |
TrendExpression | String |
ModifiedTime | DateTime |
Remarks
Corresponds to the TMSCHEMA_KPIS data management view (DMV).
As all the INFO functions, it cannot be used in calculated tables and calculated columns.
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.