You need to define the trend calculation for the sales performance KPI.
Which KPI trend MDX expression should you use?
A . CASE
WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN -1
WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE 1 END
B . IIF ([Sales Variance %3 < ([Sales Variance %], [Date].[Calendar].PrevMember), 1, 0)
C . IIF ([Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember), 0, 1)
D . CASE
WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 1
WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE -1
END
Answer: A