KPI’s creation - SSAS

KPI's Creation
Utilization Percentage
Value Expression - [Measures].[Utilization %]
Goal Expression – 70
Status - Indicator Selection like Gauge, Road Signs, Faces, etc
Expression –
CASE WHEN
[Measures].[Utilization %] > 0.7
THEN 1
WHEN
[Measures].[Utilization %] <=0.7
THEN 0
WHEN
[Measures].[Utilization %] <0.7
THEN -1
END

Trend
Indicator Selection like Standard arrow, Status arrow, etc
CASE
WHEN
[Measures].[Utilization %]>([Measures].[Utilization %],[Date].[Fiscal Time].PREVMEMBER)
THEN
1
WHEN
[Measures].[Utilization %]<([Measures].[Utilization %],[Date].[Fiscal Time].PREVMEMBER)
THEN
-1
WHEN [Measures].[Utilization %]=([Measures].[Utilization %],[Date].[Fiscal Time].PREVMEMBER)
THEN 0

END