table Fact_Retail_Total
	lineageTag: 25ae8110-f72c-4845-9206-613c06017f31

	column CORP_COD
		dataType: string
		lineageTag: 3a0400f4-4813-405c-aa33-3b3d4b693441
		summarizeBy: none
		sourceColumn: CORP_COD

		annotation SummarizationSetBy = Automatic

	column YYYYMM
		dataType: string
		lineageTag: 2a1da84d-e44c-4f87-ac89-03164b88c849
		summarizeBy: none
		sourceColumn: YYYYMM

		annotation SummarizationSetBy = Automatic

	column GEO_KEY
		dataType: string
		lineageTag: 38864f21-3626-4616-9f25-fc2b14d98051
		summarizeBy: none
		sourceColumn: GEO_KEY

		annotation SummarizationSetBy = Automatic

	column KPI_NAME
		dataType: string
		lineageTag: 016318cd-365f-484f-b82e-ca4290485d25
		summarizeBy: none
		sourceColumn: KPI_NAME

		annotation SummarizationSetBy = Automatic

	column TOTAL_FLAG
		dataType: string
		lineageTag: 4fd907fd-38d8-41da-a6ee-fb12a3b1d00f
		summarizeBy: none
		sourceColumn: TOTAL_FLAG

		annotation SummarizationSetBy = Automatic

	column DATA_SOURCE
		dataType: string
		lineageTag: a038e5f9-91a7-4ccd-82b4-50aa9fa55b1c
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column KPI_VAL
		dataType: double
		lineageTag: d8eabefa-951a-47b9-bc2b-93f7c4fab2aa
		summarizeBy: sum
		sourceColumn: KPI_VAL

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column DATE_KEY = DATE(LEFT([YYYYMM],4),RIGHT([YYYYMM],2),"01")
		formatString: General Date
		lineageTag: 44afb363-50e4-4825-b49d-1cb8030e8d45
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column TA_SOURCE = [TA] & [DATA_SOURCE]
		lineageTag: f4492a50-d51b-4db0-a485-3377907ac96a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column DTP_FLAG
		dataType: int64
		formatString: 0
		lineageTag: 8d4fdad1-a8ed-4343-befb-71954a90f7f8
		summarizeBy: sum
		sourceColumn: DTP_FLAG

		annotation SummarizationSetBy = Automatic

	column TA
		dataType: string
		lineageTag: 652ecd63-8887-44e8-9364-07005911dca8
		summarizeBy: none
		sourceColumn: TA

		annotation SummarizationSetBy = Automatic

	column KPI_VAL_LY
		dataType: double
		lineageTag: b2b04476-0267-45bd-94cd-35f35d3f5745
		summarizeBy: sum
		sourceColumn: KPI_VAL_LY

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	partition Fact_Retail_Total = m
		mode: import
		queryGroup: 首页直取KPI
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				      "SELECT CORP_COD,TA,YYYYMM,GEO_KEY,KPI_NAME,INT(DTP_FLAG) DTP_FLAG,TOTAL_FLAG,DATA_SOURCE,SUM(CAST(KPI_VAL AS DECIMAL(38,16))) KPI_VAL,SUM(CAST(KPI_VAL_LY AS DECIMAL(38,16))) KPI_VAL_LY
				         FROM dm.dm_zk_retail_sales_kpi
				        WHERE KPI_NAME IN ('top_corp_rank','corp_type_sales_amount') AND PACK_CODE = ''
				        GROUP BY CORP_COD,TA,YYYYMM,GEO_KEY,KPI_NAME,TOTAL_FLAG,DATA_SOURCE,DTP_FLAG"
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation