我有一个DAX代码,我知道在效率和性能方面可以大大提高,但我不太确定如何去做。
Total GMRR (EUR) =
SUMX (
FILTER (
SUMMARIZE (
fact_transaction_monthly,
dim_partner[partner_created_date],
dim_partner[partner_name],
"GMRR", SUM ( fact_transaction_monthly[euroConsolidatedGMRR] ),
"check", [checkActive]
),
[check] = 1
),
[GMRR]
)
我正在创建一个汇总表,并对检查等于1的值求和,但这需要很长时间来计算
检查活动代码:
checkActive =
IF ([Total Active Partners] = 1,1,0)
Total GMRR (EUR) =
SUMX (
CALCULATETABLE (
SUMMARIZE (
fact_transaction_monthly,
dim_partner[partner_created_date],
dim_partner[partner_name],
"GMRR", SUM ( fact_transaction_monthly[euroConsolidatedGMRR] )
),
[checkActive] = 1
),
[GMRR]
)