table Fields_Leader
	lineageTag: f057289f-538d-4d36-be18-3419241c9b9b

	column Fields_Leader
		lineageTag: ef567d40-2ff1-4191-b4c3-20f1b46e11b9
		summarizeBy: none
		sourceColumn: [Value1]
		sortByColumn: 'Fields_Leader 个订单'

		relatedColumnDetails
			groupByColumn: 'Fields_Leader 个字段'

		annotation SummarizationSetBy = Automatic

		annotation __PBI_SemanticLinks = [{"LinkTarget":{"TableName":"Fields_Leader","TableItemName":"Fields_Leader (组)","ObjectType":4},"LinkType":"UsedInGroup"}]

	column 'Fields_Leader 个字段'
		lineageTag: e0da0ffa-194b-4e9d-817b-a0570fb85c82
		summarizeBy: none
		sourceColumn: [Value2]
		sortByColumn: 'Fields_Leader 个订单'

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

		annotation SummarizationSetBy = Automatic

	column 'Fields_Leader 个订单'
		formatString: 0
		lineageTag: 0cb09412-2418-4bda-a7eb-9f3838c3f2ec
		summarizeBy: sum
		sourceColumn: [Value3]

		annotation SummarizationSetBy = Automatic

	column 'Fields_Leader (组)' =
			SWITCH(
				TRUE,
				ISBLANK('Fields_Leader'[Fields_Leader]),
				"(空白)",
				'Fields_Leader'[Fields_Leader] IN {"Market Leader By MS%",
					"Market Leader MS%",
					"Top Competitor By MS%",
					"Top Competitor MS%"},
				"Top brand by MS%",
				'Fields_Leader'[Fields_Leader] IN {"Market Leader By ΔMS%",
					"Market Leader ΔMS%",
					"Top Competitor By ΔMS%",
					"Top Competitor ΔMS%"},
				"Top brand by ΔMS%",
				'Fields_Leader'[Fields_Leader] IN {"Top Class By MS%",
					"Top Class MS%",
					"Top Class By ΔMS%",
					"Top Class ΔMS%"},
				"Top Class",
				'Fields_Leader'[Fields_Leader] IN {"Top Molecule By MS%",
					"Top Molecule MS%",
					"Top Molecule By ΔMS%",
					"Top Molecule ΔMS%"},
				"Top Molecule",
				'Fields_Leader'[Fields_Leader]
			)
		lineageTag: d06933bf-46f1-4d7f-94d2-a2dda2445983
		summarizeBy: none

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

		annotation GroupingDesignState = {"Version":0,"Sources":[{"Name":"f","Entity":"Fields_Leader"}],"GroupedColumns":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_Leader"}}],"GroupItems":[{"DisplayName":"(空白)","BlankDefaultPlaceholder":true},{"DisplayName":"Top brand by MS%","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_Leader"}}],"Values":[[{"Literal":{"Value":"'Market Leader By MS%'"}}],[{"Literal":{"Value":"'Market Leader MS%'"}}],[{"Literal":{"Value":"'Top Competitor By MS%'"}}],[{"Literal":{"Value":"'Top Competitor MS%'"}}]]}}},{"DisplayName":"Top brand by ΔMS%","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_Leader"}}],"Values":[[{"Literal":{"Value":"'Market Leader By ΔMS%'"}}],[{"Literal":{"Value":"'Market Leader ΔMS%'"}}],[{"Literal":{"Value":"'Top Competitor By ΔMS%'"}}],[{"Literal":{"Value":"'Top Competitor ΔMS%'"}}]]}}},{"DisplayName":"Top Class","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_Leader"}}],"Values":[[{"Literal":{"Value":"'Top Class By MS%'"}}],[{"Literal":{"Value":"'Top Class MS%'"}}],[{"Literal":{"Value":"'Top Class By ΔMS%'"}}],[{"Literal":{"Value":"'Top Class ΔMS%'"}}]]}}},{"DisplayName":"Top Molecule","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"f"}},"Property":"Fields_Leader"}}],"Values":[[{"Literal":{"Value":"'Top Molecule By MS%'"}}],[{"Literal":{"Value":"'Top Molecule MS%'"}}],[{"Literal":{"Value":"'Top Molecule By ΔMS%'"}}],[{"Literal":{"Value":"'Top Molecule ΔMS%'"}}]]}}}]}

		annotation SummarizationSetBy = Automatic

	partition Fields_Leader = calculated
		mode: import
		source =
				{
				    ("Market Leader By MS%", NAMEOF('Measure'[External.MS%.KPI.Top1PlayerName]), 1),
				    ("Market Leader MS%", NAMEOF('Measure'[External.MS%.KPI.Top1Player]), 2),
				    ("Market Leader By ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1PlayerName]), 3),
				    ("Market Leader ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1Player]), 4),
				    ("Top Competitor By MS%", NAMEOF('Measure'[External.MS%.KPI.Top1CompetitorName]), 5),
				    ("Top Competitor MS%", NAMEOF('Measure'[External.MS%.KPI.Top1Competitor]), 6),
				    ("Top Competitor By ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1CompetitorName]), 7),
				    ("Top Competitor ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1Competitor]), 8),
				
				    ("Top Molecule By MS%", NAMEOF('Measure'[External.MS%.KPI.Top1MolName]), 9),
				    ("Top Molecule MS%", NAMEOF('Measure'[External.MS%.KPI.Top1Mol]), 10),
				    ("Top Molecule By ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1MolName]), 11),
				    ("Top Molecule ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1Mol]), 12),
				
				    ("Top Class By MS%", NAMEOF('Measure'[External.MS%.KPI.Top1ClassName]), 13),
				    ("Top Class MS%", NAMEOF('Measure'[External.MS%.KPI.Top1Class]), 14),
				    ("Top Class By ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1ClassName]), 15),
				    ("Top Class ΔMS%", NAMEOF('Measure'[External.△MS%.KPI.Top1Class]), 16)
				}

	annotation PBI_Id = 51c22162b1884710bd3b85c76799470e