Measure: Internet Current Quarter Sales 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 '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';

Collapse image See also


About this documentation