table Fields_TopPlayer lineageTag: 16647b5b-d207-4533-99d9-6bb1e740233e column Fields_TopPlayer lineageTag: 92ae616f-2093-4465-ade3-beb2f4a3f10e summarizeBy: none sourceColumn: [Value1] sortByColumn: '参数1 个订单' relatedColumnDetails groupByColumn: '参数1 个字段' annotation SummarizationSetBy = Automatic annotation __PBI_SemanticLinks = [{"LinkTarget":{"TableName":"Fields_TopPlayer","TableItemName":"Fields_TopPlayer (组)","ObjectType":4},"LinkType":"UsedInGroup"}] column '参数1 个字段' isHidden lineageTag: a8e79fe3-7651-44a7-b2f4-e2ea172357cc summarizeBy: none sourceColumn: [Value2] sortByColumn: '参数1 个订单' extendedProperty ParameterMetadata = { "version": 3, "kind": 2 } annotation SummarizationSetBy = Automatic column '参数1 个订单' isHidden formatString: 0 lineageTag: 2b714f77-791d-4d9d-99cc-de3e022fef0f summarizeBy: sum sourceColumn: [Value3] annotation SummarizationSetBy = Automatic column 'Fields_TopPlayer (组)' = SWITCH( TRUE, ISBLANK('Fields_TopPlayer'[Fields_TopPlayer]), "(空白)", 'Fields_TopPlayer'[Fields_TopPlayer] IN {"Top1 Brand", "Top1 Brand Sales", "Top1 Brand GR%", "Top1 Incremental Brand", "Top1 Incremental Brand Sales", "Top1 Incremental Brand GR%"}, "Top1 Brand", 'Fields_TopPlayer'[Fields_TopPlayer] IN {"Top2 Brand", "Top2 Brand Sales", "Top2 Brand GR%", "Top2 Incremental Brand", "Top2 Incremental Brand Sales", "Top2 Incremental Brand GR%"}, "Top2 Brand", "Others" ) lineageTag: 1299ed3b-1372-42ac-bfa1-4621b7c91b39 summarizeBy: none extendedProperty GroupingMetadata = { "version": 0, "groupedColumns": [ { "Column": { "Expression": { "SourceRef": { "Entity": "Fields_TopPlayer" } }, "Property": "Fields_TopPlayer" } } ] } annotation GroupingDesignState = {"Version":0,"Sources":[{"Name":"f","Entity":"Fields_TopPlayer"}],"GroupedColumns":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_TopPlayer"}}],"GroupItems":[{"DisplayName":"(空白)","BlankDefaultPlaceholder":true},{"DisplayName":"Top1 Brand","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_TopPlayer"}}],"Values":[[{"Literal":{"Value":"'Top1 Brand'"}}],[{"Literal":{"Value":"'Top1 Brand Sales'"}}],[{"Literal":{"Value":"'Top1 Brand GR%'"}}],[{"Literal":{"Value":"'Top1 Incremental Brand'"}}],[{"Literal":{"Value":"'Top1 Incremental Brand Sales'"}}],[{"Literal":{"Value":"'Top1 Incremental Brand GR%'"}}]]}}},{"DisplayName":"Top2 Brand","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_TopPlayer"}}],"Values":[[{"Literal":{"Value":"'Top2 Brand'"}}],[{"Literal":{"Value":"'Top2 Brand Sales'"}}],[{"Literal":{"Value":"'Top2 Brand GR%'"}}],[{"Literal":{"Value":"'Top2 Incremental Brand'"}}],[{"Literal":{"Value":"'Top2 Incremental Brand Sales'"}}],[{"Literal":{"Value":"'Top2 Incremental Brand GR%'"}}]]}}},{"DisplayName":"Others"}]} annotation SummarizationSetBy = Automatic partition Fields_TopPlayer = calculated mode: import source = { ("Top1 Brand", NAMEOF([Sales_MSTOP1_BrandName]), 0), ("Top1 Brand Sales", NAMEOF([Sales_MSTOP1_BrandSales]), 1), ("Top1 Brand GR%", NAMEOF([Sales_MSTOP1_BrandGR%]), 2), ("Top2 Brand", NAMEOF([Sales_MSTOP2_BrandName]), 3), ("Top2 Brand Sales", NAMEOF([Sales_MSTOP2_BrandSales]), 4), ("Top2 Brand GR%", NAMEOF([Sales_MSTOP2_BrandGR%]), 5), ("Top1 Incremental Brand", NAMEOF([Sales_GRTOP1_BrandName]), 6), ("Top1 Incremental Brand Sales", NAMEOF([Sales_GRTOP1_BrandSales]), 7), ("Top1 Incremental Brand GR%", NAMEOF([Sales_GRTOP1_BrandGR%]), 8), ("Top2 Incremental Brand", NAMEOF([Sales_GRTOP2_BrandName]), 9), ("Top2 Incremental Brand Sales", NAMEOF([Sales_GRTOP2_BrandSales]), 10), ("Top2 Incremental Brand GR%", NAMEOF([Sales_GRTOP2_BrandGR%]), 11) } annotation PBI_Id = 8150531c43e0490c95a42d7d15d7cf36