KPIValue (MDX)
Returns the member that calculates the value of the specified Key Performance Indicator (KPI).
Syntax
KPIValue(KPI_Name)
Arguments
KPI_Name
A valid string expression that specifies the name of the KPI.
Remarks
Example
The following example returns the KPI value, KPI goal, KPI status, and KPI trend for the channel revenue measure for the descendants of three members of the Fiscal Year attribute hierarchy.
SELECT
{ KPIValue("Channel Revenue"),
KPIGoal("Channel Revenue"),
KPIStatus("Channel Revenue"),
KPITrend("Channel Revenue")
} ON Columns,
Descendants
( { [Date].[Fiscal].[Fiscal Year].&[2002],
[Date].[Fiscal].[Fiscal Year].&[2003],
[Date].[Fiscal].[Fiscal Year].&[2004]
}, [Date].[Fiscal].[Fiscal Quarter]
) ON Rows
FROM [Adventure Works]
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for