108 lines
4.2 KiB
Plaintext
108 lines
4.2 KiB
Plaintext
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
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|