Measure: Internet Current Quarter Sales Performance
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 'Internet Sales'[Internet Current Quarter Sales Performance]=IFERROR([Internet Current Quarter Sales]/[Internet Previous Quarter Sales Proportion to QTD],BLANK()); CREATE MEASURE 'Internet Sales'[_Internet Current Quarter Sales Performance Goal] = 1.1; CREATE MEASURE 'Internet Sales'[_Internet Current Quarter Sales Performance Status] = if(ISBLANK('Internet Sales'[Internet Current Quarter Sales Performance]),BLANK(), If('Internet Sales'[Internet Current Quarter Sales Performance]<1,-1, If('Internet Sales'[Internet Current Quarter Sales Performance]<1.07,0,1) ) ) ; CREATE KPI CURRENTCUBE.[Internet Current Quarter Sales Performance] AS Measures.[Internet Current Quarter Sales Performance], ASSOCIATED_MEASURE_GROUP = 'Internet Sales', GOAL = Measures.[_Internet Current Quarter Sales Performance Goal], STATUS = Measures.[_Internet Current Quarter Sales Performance Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored'; |
See also