table AIA_Decile_CalGroup lineageTag: 58c67585-06ec-42ab-9a98-36b066c8d071 calculationGroup precedence: 4 calculationItem AIA_Sales_FRpage = ``` IF( NOT ( ISEMPTY ( INTERSECT ( { 109, 110 ,114}, VALUES ( 'AIA.Fields.Rows'[AIA.Fields.Rows Order] ) ) ) ) || ( ISFILTERED ( Dim_HP_Potential_AIA[DECILE] ) || ISFILTERED ( Dim_HP_Potential_AIA[DECILE_GROUP] ) || ISFILTERED( Dim_IsEagle_AIASpecial[is_eagle] ) ), IF(ISFILTERED ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) && ISFILTERED ( Dim_Market[MARKET] ) || SELECTEDMEASURENAME() IN {"show_filters.AIA","4.1 DECILE_TEXT","4.1 POTENTIAL_TEXT"}, SELECTEDMEASURE()), CALCULATE ( SELECTEDMEASURE(), ALL ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) ) ) // IF( NOT ISEMPTY ( // INTERSECT ( { 109, 110 }, VALUES ( 'AIA.Fields.Rows'[AIA.Fields.Rows Order] ) )), // IF(ISFILTERED ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) && ISFILTERED ( Dim_Market[MARKET] ) || SELECTEDMEASURENAME() IN {"show_filters.AIA","4.1 DECILE_TEXT","4.1 POTENTIAL_TEXT"}, // SELECTEDMEASURE()), // CALCULATE ( // SELECTEDMEASURE(), // ALL ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) ) // ) ``` calculationItem AIA_Sales_MApage = ``` IF( NOT ISEMPTY ( INTERSECT ( { 8,9 }, VALUES ( 'AIA.Fields_Geo'[AIA.Fields_Geo 个订单] ))), IF(ISFILTERED ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) && ISFILTERED ( Dim_Market[MARKET] )||SELECTEDMEASURENAME() ="AIA.warning2.3", SELECTEDMEASURE()), CALCULATE ( SELECTEDMEASURE(), ALL ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) ) ) ``` calculationItem AIA_Sales_AApage_3_1 = ``` IF( (NOT ISEMPTY ( INTERSECT ( { 8,9 }, VALUES ( 'AIA.Fields_Geo'[AIA.Fields_Geo 个订单] )))) || OR ( ISFILTERED ( Dim_HP_Potential_AIA[DECILE] ), ISFILTERED ( Dim_HP_Potential_AIA[DECILE_GROUP] ) ), IF(ISFILTERED ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) && ISFILTERED ( Dim_Market[MARKET] ), SELECTEDMEASURE()), CALCULATE ( SELECTEDMEASURE(), ALL ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) ) ) ``` calculationItem AIA_Sales_AApage_3_2 = ``` IF( (NOT ISEMPTY ( INTERSECT ( { 0,1 }, VALUES ( 'AIA.Fields_Decile'[AIA.Fields_Decile 个订单] )))) || OR ( ISFILTERED ( Dim_HP_Potential_AIA[DECILE] ), ISFILTERED ( Dim_HP_Potential_AIA[DECILE_GROUP] ) ), IF(ISFILTERED ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) && ISFILTERED ( Dim_Market[MARKET] ), SELECTEDMEASURE()), CALCULATE ( SELECTEDMEASURE(), ALL ( Dim_HP_Potential_AIA[IS_DEFAULT_MKT_FLAG] ) ) ) ``` column AIA_FreeReport dataType: string lineageTag: 009e7d2c-48cc-45d7-b073-bbb246091b11 summarizeBy: none sourceColumn: Name sortByColumn: Ordinal annotation SummarizationSetBy = Automatic column Ordinal dataType: int64 formatString: 0 lineageTag: 1fe615fa-c4eb-4f0a-8f4b-7e003947dcd7 summarizeBy: sum sourceColumn: Ordinal annotation SummarizationSetBy = Automatic