Measure: Reseller Current Quarter Gross Profit 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 'Reseller Sales'[Reseller Current Quarter Gross Profit Performance]=IF([Reseller Previous Quarter Gross Profit Proportion to QTD]<>0,([Reseller Current Quarter Gross Profit]-[Reseller Previous Quarter Gross Profit Proportion to QTD])/[Reseller Previous Quarter Gross Profit Proportion to QTD],BLANK());
CREATE MEASURE 'Reseller Sales'[_Reseller Current Quarter Gross Profit Performance Goal] = 1.25; 
CREATE MEASURE 'Reseller Sales'[_Reseller Current Quarter Gross Profit Performance Status] = if(ISBLANK('Reseller Sales'[Reseller Current Quarter Gross Profit Performance]),BLANK(),
        If('Reseller Sales'[Reseller Current Quarter Gross Profit Performance]<0.8,-1,
        If('Reseller Sales'[Reseller Current Quarter Gross Profit Performance]<1.03,0,1)
    )
)
; 
CREATE KPI CURRENTCUBE.[Reseller Current Quarter Gross Profit Performance] AS Measures.[Reseller Current Quarter Gross Profit Performance], ASSOCIATED_MEASURE_GROUP = 'Reseller Sales', GOAL = Measures.[_Reseller Current Quarter Gross Profit Performance Goal], STATUS = Measures.[_Reseller Current Quarter Gross Profit Performance Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored';

Collapse image See also


About this documentation