You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months. What should you use to define…

The correct answer is D. a measure. Must be a measure because "last 12 months" is dynamic. You won't reach this requirement with an absolute value.

Model data by using Microsoft Excel

Question

You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12 months. What should you use to define the target value?

Options

Aan absolute value
Ba calculated column
Ca calculated field
Da measure

How the community answered

(49 responses)

A
10% (5)
B
4% (2)
C
14% (7)
D
71% (35)

Explanation

Must be a measure because "last 12 months" is dynamic. You won't reach this requirement with an absolute value.

Topics

#KPI#target value#measures#DAX

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice