Measure: Products UnderStocked
Measure properties
| Property | Value |
| Format | |
| Format string | '' |
| Measure type | Kpi |
| Is default field set | False |
Command
---------------------------------------------------------- -- PowerPivot measures command (do not modify manually) -- ---------------------------------------------------------- CREATE MEASURE 'Product Inventory'[Products UnderStocked]=CALCULATE(SUM([Product-Date UnderStocked]),LASTDATE('Product Inventory'[Movement Date])); CREATE MEASURE 'Product Inventory'[_Products UnderStocked Goal] = 0; CREATE MEASURE 'Product Inventory'[_Products UnderStocked Status] = if(ISBLANK('Product Inventory'[Products UnderStocked]),BLANK(), If('Product Inventory'[Products UnderStocked]<5,1, If('Product Inventory'[Products UnderStocked]<15,0,-1) ) ) ; CREATE KPI CURRENTCUBE.[Products UnderStocked] AS Measures.[Products UnderStocked], ASSOCIATED_MEASURE_GROUP = 'Product Inventory', GOAL = Measures.[_Products UnderStocked Goal], STATUS = Measures.[_Products UnderStocked Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored'; |
See also