I have a simple calculation MyBase = SUM('MyData'[Amount])
and I would like to include an ifelse statement in Calculate
. The condition is IF [Currency Type] = "USD" THEN [MyBase]/2 Otherwise
print out the code below.
MyCalculate =
CALCULATE(
[MyBase],
KEEPFILTERS('MyData'[Currency] = "USD"),
KEEPFILTERS('MyData'[Scenario] = "AOP")
)