我有一个简单的计算MyBase = SUM('MyData'[Amount])
,我想在Calculate
. 条件是IF [Currency Type] = "USD" THEN [MyBase]/2 Otherwise
打印出下面的代码。
MyCalculate =
CALCULATE(
[MyBase],
KEEPFILTERS('MyData'[Currency] = "USD"),
KEEPFILTERS('MyData'[Scenario] = "AOP")
)
1 个回答