Measure: Total Current Quarter Gross Profit Performance
Property | Value |
Format | |
Format string | '' |
Measure type | Kpi |
Is default field set | False |
---------------------------------------------------------- -- PowerPivot measures command (do not modify manually) -- ---------------------------------------------------------- CREATE MEASURE 'Sales Territory'[Total Current Quarter Gross Profit Performance]=IF([Total Previous Quarter Gross Profit Proportion to QTD]<>0,([Total Current Quarter Gross Profit]-[Total Previous Quarter Gross Profit Proportion to QTD])/[Total Previous Quarter Gross Profit Proportion to QTD],BLANK()); CREATE MEASURE 'Sales Territory'[_Total Current Quarter Gross Profit Performance Goal] = 1.25; CREATE MEASURE 'Sales Territory'[_Total Current Quarter Gross Profit Performance Status] = if(ISBLANK('Sales Territory'[Total Current Quarter Gross Profit Performance]),BLANK(), If('Sales Territory'[Total Current Quarter Gross Profit Performance]<0.8,-1, If('Sales Territory'[Total Current Quarter Gross Profit Performance]<1.03,0,1) ) ) ; CREATE KPI CURRENTCUBE.[Total Current Quarter Gross Profit Performance] AS Measures.[Total Current Quarter Gross Profit Performance], ASSOCIATED_MEASURE_GROUP = 'Sales Territory', GOAL = Measures.[_Total Current Quarter Gross Profit Performance Goal], STATUS = Measures.[_Total Current Quarter Gross Profit Performance Status], STATUS_GRAPHIC = 'Three Symbols UnCircled Colored'; |