// DAX Query
DEFINE
---- MODEL MEASURES BEGIN ----
MEASURE 'FACT'[xx1] =
CALCULATE (
SUM ( 'FACT'[offtake_value] ),
'FACT'[offtake_value] <> 0
)
MEASURE 'FACT'[xx2] =
SUM ( 'FACT'[offtake_value] )
MEASURE 'FACT'[xx3] =
CALCULATE (
SUM ( 'FACT'[offtake_value] ),
DATEADD ( 'Dim Calendar'[Date], -1, YEAR )
)
MEASURE 'FACT'[xx4] =
VAR d =
MAX ( 'Dim Calendar'[Date] )
RETURN
CALCULATE (
SUM ( 'FACT'[offtake_value] ),
KEEPFILTERS ( 'Dim Calendar'[Date] = EDATE ( d, -12 ) )
)
MEASURE 'FACT'[xx5] =
VAR d =
MAX ( 'Dim Calendar'[Date] )
VAR dd =
DATE ( YEAR ( d ) - 1, MONTH ( d ), DAY ( d ) )
RETURN
CALCULATE (
SUM ( 'FACT'[offtake_value] ),
KEEPFILTERS ( 'Dim Calendar'[Date] = d )
)
---- MODEL MEASURES END ----
VAR __DS0Core =
SUMMARIZECOLUMNS (
ROLLUPADDISSUBTOTAL ( 'Dim Store'[banner_name_en], "IsGrandTotalRowTotal" ),
"All_UPI_", 'FACT'[xx5]
)
VAR __DS0PrimaryWindowed =
TOPN (
502,
__DS0Core,
[IsGrandTotalRowTotal], 0,
'Dim Store'[banner_name_en], 1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[IsGrandTotalRowTotal] DESC,
'Dim Store'[banner_name_en]
求去年單天DATEADD ( 'Dim Calendar'[Date], -1, YEAR )明顯最慢
