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