Measure: Products with Negative Stock

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'[Products with Negative Stock]=CALCULATE(SUM([Product-Date Negative Stock]),LASTDATE('Product Inventory'[Movement Date]));
CREATE MEASURE 'Product Inventory'[_Products with Negative Stock Goal] = 0; 
CREATE MEASURE 'Product Inventory'[_Products with Negative Stock Status] = if(ISBLANK('Product Inventory'[Products with Negative Stock]),BLANK(),
        If('Product Inventory'[Products with Negative Stock]<0.1,1,
        If('Product Inventory'[Products with Negative Stock]<5,0,-1)
    )
)
; 
CREATE KPI CURRENTCUBE.[Products with Negative Stock] AS Measures.[Products with Negative Stock], ASSOCIATED_MEASURE_GROUP = 'Product Inventory', GOAL = Measures.[_Products with Negative Stock Goal], STATUS = Measures.[_Products with Negative Stock Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored';

Collapse image See also


About this documentation