Measure: Total Inventory Value Performance

CollapseAll image

Collapse image Measure properties


 Property   Value 
 Format    
 Format string   '' 
 Measure type   Kpi 
 Is default field set   False 

Collapse image Command


----------------------------------------------------------
-- PowerPivot measures command (do not modify manually) --
----------------------------------------------------------


CREATE MEASURE 'Product Inventory'[Total Inventory Value Performance]=IF([Total Inventory Value]<[Total Inventory Optimal Value],-(1-([Total Inventory Value]/[Total Inventory Optimal Value])),([Total Inventory Value]-[Total Inventory Optimal Value])/([Total Inventory Maximum Value]-[Total Inventory Optimal Value]));
CREATE MEASURE 'Product Inventory'[_Total Inventory Value Performance Goal] = 0; 
CREATE MEASURE 'Product Inventory'[_Total Inventory Value Performance Status] = if(ISBLANK('Product Inventory'[Total Inventory Value Performance]),BLANK(),
    If('Product Inventory'[Total Inventory Value Performance]<0,
        If('Product Inventory'[Total Inventory Value Performance]<-0.2,-1,0),
        If('Product Inventory'[Total Inventory Value Performance]<0.6,1,
            If('Product Inventory'[Total Inventory Value Performance]<1,0,-1)
        )
    )
)
; 
CREATE KPI CURRENTCUBE.[Total Inventory Value Performance] AS Measures.[Total Inventory Value Performance], ASSOCIATED_MEASURE_GROUP = 'Product Inventory', GOAL = Measures.[_Total Inventory Value Performance Goal], STATUS = Measures.[_Total Inventory Value Performance Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored';

Collapse image See also


About this documentation