table Fields_TopPlayer_EN
	lineageTag: 77b7a229-17db-4911-be89-6800811a6ced

	column TopPlayer_EN
		lineageTag: a22f26aa-4f47-44e1-bb0d-b5fd4a0546ff
		summarizeBy: none
		sourceColumn: [Value1]
		sortByColumn: 'TopPlayer_EN Order'

		relatedColumnDetails
			groupByColumn: 'TopPlayer_EN Fields'

		annotation SummarizationSetBy = Automatic

		annotation __PBI_SemanticLinks = [{"LinkTarget":{"TableName":"Fields_TopPlayer_EN","TableItemName":"TopPlayer_EN (groups)","ObjectType":4},"LinkType":"UsedInGroup"}]

	column 'TopPlayer_EN Fields'
		isHidden
		lineageTag: da1778cb-48fb-479e-be52-35abae4518c3
		summarizeBy: none
		sourceColumn: [Value2]
		sortByColumn: 'TopPlayer_EN Order'

		extendedProperty ParameterMetadata =
				{
				  "version": 3,
				  "kind": 2
				}

		annotation SummarizationSetBy = Automatic

	column 'TopPlayer_EN Order'
		isHidden
		formatString: 0
		lineageTag: aaef0f8c-fc34-4eda-842f-54046488133d
		summarizeBy: sum
		sourceColumn: [Value3]

		annotation SummarizationSetBy = Automatic

	column 'TopPlayer_EN (groups)' =
			SWITCH(
				TRUE,
				ISBLANK('Fields_TopPlayer_EN'[TopPlayer_EN]),
				"(Blank)",
				'Fields_TopPlayer_EN'[TopPlayer_EN] IN {"Top1 Brand",
					"Top1 Brand Sales",
					"Top1 Brand GR%",
					"Top1 Incremental Brand",
					"Top1 Incremental Brand Sales",
					"Top1 Incremental Brand GR%"},
				"Top1 Brand",
				'Fields_TopPlayer_EN'[TopPlayer_EN] IN {"Top2 Brand",
					"Top2 Brand Sales",
					"Top2 Brand GR%",
					"Top2 Incremental Brand",
					"Top2 Incremental Brand Sales",
					"Top2 Incremental Brand GR%"},
				"Top2 Brand",
				'Fields_TopPlayer_EN'[TopPlayer_EN]
			)
		lineageTag: ebdc207e-4eb8-4f21-9cf4-f6546ae327a0
		summarizeBy: none

		extendedProperty GroupingMetadata =
				{
				  "version": 0,
				  "groupedColumns": [
				    {
				      "Column": {
				        "Expression": {
				          "SourceRef": {
				            "Entity": "Fields_TopPlayer_EN"
				          }
				        },
				        "Property": "TopPlayer_EN"
				      }
				    }
				  ]
				}

		annotation GroupingDesignState = {"Version":0,"Sources":[{"Name":"f","Entity":"Fields_TopPlayer_EN"}],"GroupedColumns":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"TopPlayer_EN"}}],"GroupItems":[{"DisplayName":"(Blank)","BlankDefaultPlaceholder":true},{"DisplayName":"Top1 Brand","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"TopPlayer_EN"}}],"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":"TopPlayer_EN"}}],"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%'"}}]]}}}]}

		annotation SummarizationSetBy = Automatic

	partition Fields_TopPlayer_EN = calculated
		mode: import
		source =
				{
				    ("Top1 Brand", NAMEOF([Sales_MSTOP1_BrandName.EN]), 0),
				    ("Top1 Brand Sales", NAMEOF([Sales_MSTOP1_BrandSales]), 1),
				    ("Top1 Brand GR%", NAMEOF([Sales_MSTOP1_BrandGR%.EN]), 2),
				    ("Top2 Brand", NAMEOF([Sales_MSTOP2_BrandName.EN]), 3),
				    ("Top2 Brand Sales", NAMEOF([Sales_MSTOP2_BrandSales]), 4),
				    ("Top2 Brand GR%", NAMEOF([Sales_MSTOP2_BrandGR%.EN]), 5),
				    ("Top1 Incremental Brand", NAMEOF([Sales_GRTOP1_BrandName.EN]), 6),
				    ("Top1 Incremental Brand Sales", NAMEOF([Sales_GRTOP1_BrandSales]), 7),
				    ("Top1 Incremental Brand GR%", NAMEOF([Sales_GRTOP1_BrandGR%.EN]), 8),
				    ("Top2 Incremental Brand", NAMEOF([Sales_GRTOP2_BrandName.EN]), 9),
				    ("Top2 Incremental Brand Sales", NAMEOF([Sales_GRTOP2_BrandSales]), 10),
				    ("Top2 Incremental Brand GR%", NAMEOF([Sales_GRTOP2_BrandGR%.EN]), 11)
				}

	annotation PBI_Id = 5c1a608ef72443e8b56dbcfc2f3e87b0