INFO.KPIS DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Returns a list of all KPIS in the current model with columns matching the schema rowset for KPI objects.

Syntax

INFO.KPIS ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

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: Nov 14, 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.