Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 329

1. You can add a KPI by right-clicking on the calculated measure or using the
Create KPI icon on the ribbon. This will open the following screenshot:
If you look at the preceding screenshot, you will notice the four key elements
that make up a KPI: KPI base measure, target value, status thresholds, and
icon style. Let's work through each element.
2. When you create the KPI, you select a calculated measure in the measure
grid. This becomes the base measure. The role of the base measure is the
value which will be measured against the target value. In our example, Cost
Percent is our KPI base measure.
3. The target value can be sourced from one of two areas. The first option is
to use another calculated measure. You would use that option when you can
use calculation for targets. For instance, if you created a calculation to rep-