128 lines
5.2 KiB
Plaintext
128 lines
5.2 KiB
Plaintext
table 'retail 自有页面kpi'
|
|
lineageTag: 5ed769fd-d9d6-49a3-848f-1d54247c12e7
|
|
|
|
column 'retail 自有页面kpi'
|
|
lineageTag: dfe388e7-f87a-4c2c-9104-bdd803d0e9bd
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: '参数 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: '参数 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column '参数 个字段'
|
|
isHidden
|
|
lineageTag: 0aa45fef-abef-41ff-af5c-ec072e74c7cb
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: '参数 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation __PBI_SemanticLinks = [{"LinkTarget":{"TableName":"retail 自有页面kpi","TableItemName":"参数 个字段 (组)","ObjectType":4},"LinkType":"UsedInGroup"},{"LinkTarget":{"TableName":"retail 自有页面kpi","TableItemName":"参数 个字段 (组) 2","ObjectType":4},"LinkType":"UsedInGroup"}]
|
|
|
|
column '参数 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: 4c425ca8-264b-4b3a-a27d-b897427fae0b
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column '参数 个字段 (组)' =
|
|
SWITCH(
|
|
TRUE,
|
|
ISBLANK('retail 自有页面kpi'[参数 个字段]),
|
|
"(空白)",
|
|
'retail 自有页面kpi'[参数 个字段] IN {"'Measure'[retail 加权铺货率]",
|
|
"'Measure'[retail 加权铺货率 Δ]"},
|
|
"加权铺货率",
|
|
'retail 自有页面kpi'[参数 个字段] IN {"'Measure'[retail 数字铺货率]",
|
|
"'Measure'[retail 数字铺货率 Δ]"},
|
|
"数字铺货率",
|
|
'retail 自有页面kpi'[参数 个字段]
|
|
)
|
|
lineageTag: 618e3eaa-608e-4f86-9073-2c7040ea4bff
|
|
summarizeBy: none
|
|
|
|
extendedProperty GroupingMetadata =
|
|
{
|
|
"version": 0,
|
|
"groupedColumns": [
|
|
{
|
|
"Column": {
|
|
"Expression": {
|
|
"SourceRef": {
|
|
"Entity": "retail 自有页面kpi"
|
|
}
|
|
},
|
|
"Property": "参数 个字段"
|
|
}
|
|
}
|
|
]
|
|
}
|
|
|
|
annotation GroupingDesignState = {"Version":0,"Sources":[{"Name":"r","Entity":"retail 自有页面kpi"}],"GroupedColumns":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"GroupItems":[{"DisplayName":"(空白)","BlankDefaultPlaceholder":true},{"DisplayName":"加权铺货率","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"Values":[[{"Literal":{"Value":"'''Measure''[retail 加权铺货率]'"}}],[{"Literal":{"Value":"'''Measure''[retail 加权铺货率 Δ]'"}}]]}}},{"DisplayName":"数字铺货率","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"Values":[[{"Literal":{"Value":"'''Measure''[retail 数字铺货率]'"}}],[{"Literal":{"Value":"'''Measure''[retail 数字铺货率 Δ]'"}}]]}}}]}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column '参数 个字段 (组) 2' =
|
|
SWITCH(
|
|
TRUE,
|
|
ISBLANK('retail 自有页面kpi'[参数 个字段]),
|
|
"(空白)",
|
|
'retail 自有页面kpi'[参数 个字段] IN {"'Measure'[retail 加权铺货率]",
|
|
"'Measure'[retail 数字铺货率]"},
|
|
"Distribution",
|
|
'retail 自有页面kpi'[参数 个字段] IN {"'Measure'[retail 加权铺货率 Δ]",
|
|
"'Measure'[retail 数字铺货率 Δ]"},
|
|
"ΔDistribution",
|
|
'retail 自有页面kpi'[参数 个字段]
|
|
)
|
|
lineageTag: 41e1a853-d2a2-41fe-8121-8b340b47951f
|
|
summarizeBy: none
|
|
|
|
extendedProperty GroupingMetadata =
|
|
{
|
|
"version": 0,
|
|
"groupedColumns": [
|
|
{
|
|
"Column": {
|
|
"Expression": {
|
|
"SourceRef": {
|
|
"Entity": "retail 自有页面kpi"
|
|
}
|
|
},
|
|
"Property": "参数 个字段"
|
|
}
|
|
}
|
|
]
|
|
}
|
|
|
|
annotation GroupingDesignState = {"Version":0,"Sources":[{"Name":"r","Entity":"retail 自有页面kpi"}],"GroupedColumns":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"GroupItems":[{"DisplayName":"(空白)","BlankDefaultPlaceholder":true},{"DisplayName":"Distribution","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"Values":[[{"Literal":{"Value":"'''Measure''[retail 加权铺货率]'"}}],[{"Literal":{"Value":"'''Measure''[retail 数字铺货率]'"}}]]}}},{"DisplayName":"ΔDistribution","Expression":{"In":{"Expressions":[{"Column":{"Expression":{"SourceRef":{"Source":"r"}},"Property":"参数 个字段"}}],"Values":[[{"Literal":{"Value":"'''Measure''[retail 加权铺货率 Δ]'"}}],[{"Literal":{"Value":"'''Measure''[retail 数字铺货率 Δ]'"}}]]}}}]}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition 'retail 自有页面kpi' = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("Distribution", NAMEOF('Measure'[retail 加权铺货率]), 0),
|
|
("Δ Distribution", NAMEOF('Measure'[retail 加权铺货率 Δ]), 1),
|
|
("Distribution", NAMEOF('Measure'[retail 数字铺货率]), 2),
|
|
("Δ Distribution", NAMEOF('Measure'[retail 数字铺货率 Δ]), 3)}
|
|
|
|
annotation PBI_Id = 46deba90fef443998c8236c65c6cf9fd
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|