我有一个
code
结果如下
EVALUATE
VAR AggregatedSalesInCurrency =
ADDCOLUMNS (
SUMMARIZE(
'OPC SUMMARY (2)',
'Calendar'[Date],
'dimCurrency'[Currency Code]
),
"@SalesAmountInCurrency", [Sales (Internal)],
"@Rate", CALCULATE (
SELECTEDVALUE ( 'factFX'[FX Rate] )
)
)
RETURN
AggregatedSalesInCurrency
但是如果我添加SUMX函数
the expression specified in the query is not a valid table expression
为什么会这样?非常感谢。
EVALUATE
VAR AggregatedSalesInCurrency =
ADDCOLUMNS (
SUMMARIZE(
'OPC SUMMARY (2)',
'Calendar'[Date],
'dimCurrency'[Currency Code]
),
"@SalesAmountInCurrency", [Sales (Internal)],
"@Rate", CALCULATE (
SELECTEDVALUE ( 'factFX'[FX Rate] )
)
)
//RETURN
//AggregatedSalesInCurrency
VAR Result =
SUMX (
AggregatedSalesInCurrency,
[@SalesAmountInCurrency] / [@Rate]
)
RETURN
Result