129 lines
3.8 KiB
Plaintext
129 lines
3.8 KiB
Plaintext
table 0_Measure_CalGroup
|
|
lineageTag: c4a5ce61-56b8-48b3-9c58-2bdd2bcbb70e
|
|
|
|
calculationGroup
|
|
precedence: 11
|
|
|
|
calculationItem _allmkt =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS ( VALUES ( Fact_Sales[PACK_COD] ) ),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA ),
|
|
Fact_Sales[MARKET] = "all market"
|
|
)
|
|
|
|
calculationItem _not_allmkt = CALCULATE( SELECTEDMEASURE( ), KEEPFILTERS( Fact_Sales[MARKET] <> "all market" ) )
|
|
|
|
calculationItem _allmkt_TA =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS (
|
|
CALCULATETABLE (
|
|
VALUES ( Fact_Sales[PACK_COD] ),
|
|
Fact_Sales[MARKET] <> "all market"
|
|
)
|
|
),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA[TA] ),
|
|
Fact_Sales[MARKET] = "all market"
|
|
)
|
|
|
|
calculationItem _allmkt_niad =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS ( VALUES ( Fact_Sales[PACK_COD] ) ),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA ),
|
|
Fact_Sales_NIAD[MARKET] = "all market"
|
|
)
|
|
|
|
calculationItem _not_allmkt_niad = CALCULATE( SELECTEDMEASURE( ), KEEPFILTERS( Fact_Sales_NIAD[MARKET] <> "all market" ) )
|
|
|
|
calculationItem _allmkt_TA_niad =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS (
|
|
CALCULATETABLE (
|
|
VALUES ( Fact_Sales[PACK_COD] ),
|
|
Fact_Sales_NIAD[MARKET] <> "all market"
|
|
)
|
|
),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA[TA] ),
|
|
Fact_Sales_NIAD[MARKET] = "all market"
|
|
)
|
|
|
|
calculationItem _price_page_allmkt_switch =
|
|
IF (--如果筛选market相关
|
|
ISFILTERED ( Dim_Market[MARKET] )
|
|
|| ISFILTERED ( Dim_MarketTA[TA] )
|
|
|| ISFILTERED ( Dim_BrandDefaultMKT[BRAND_NAME] ),
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS (
|
|
Dim_PackInfo[DATA_SOURCE] = "Retail(Quarterly)"
|
|
),
|
|
TREATAS (
|
|
CALCULATETABLE (
|
|
VALUES ( Fact_Sales[PACK_COD] ),
|
|
Fact_Sales[MARKET] <> "all market"
|
|
),
|
|
Dim_PackInfo[PACK_COD]
|
|
)
|
|
),
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS (
|
|
Dim_PackInfo[DATA_SOURCE] = "Retail(Quarterly)"
|
|
),
|
|
TREATAS (
|
|
CALCULATETABLE (
|
|
VALUES ( Fact_Sales[PACK_COD] ),
|
|
Fact_Sales[MARKET] = "all market"
|
|
),
|
|
Dim_PackInfo[PACK_COD]
|
|
)
|
|
)
|
|
)
|
|
|
|
calculationItem _allmkt_thc =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS ( VALUES ( Fact_Sales_thc[PACK_COD] ) ),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA ),
|
|
Fact_Sales_thc[MARKET] = "all market"
|
|
)
|
|
|
|
calculationItem _not_allmkt_thc = CALCULATE( SELECTEDMEASURE( ), KEEPFILTERS( Fact_Sales_thc[MARKET] <> "all market" ) )
|
|
|
|
calculationItem _allmkt_TA_thc =
|
|
CALCULATE (
|
|
SELECTEDMEASURE ( ),
|
|
KEEPFILTERS (
|
|
CALCULATETABLE (
|
|
VALUES ( Fact_Sales_thc[PACK_COD] ),
|
|
Fact_Sales_thc[MARKET] <> "all market"
|
|
)
|
|
),
|
|
REMOVEFILTERS ( Dim_Market[MARKET] ),
|
|
REMOVEFILTERS ( Dim_MarketTA[TA] ),
|
|
Fact_Sales_thc[MARKET] = "all market"
|
|
)
|
|
|
|
column for_measure
|
|
dataType: string
|
|
lineageTag: daa1dfa2-573f-47cb-9ad6-1985b05ce72e
|
|
sourceColumn: Name
|
|
sortByColumn: Ordinal
|
|
|
|
column Ordinal
|
|
dataType: int64
|
|
isHidden
|
|
lineageTag: 9d14e53a-9456-4f28-aa70-d17d19ae5f03
|
|
sourceColumn: Ordinal
|
|
|
|
annotation TabularEditor_TableGroup = 02_CalGroup
|
|
|