Measure: Products with Negative Stock
Property | Value |
Format | |
Format string | '' |
Measure type | Kpi |
Is default field set | False |
---------------------------------------------------------- -- 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'; |