Database Reference
In-Depth Information
Creating a KPI
Key Performance Indicators
(
KPI
s) are used to visualize specific metrics that rep-
resent the overall health of what is being measured, such as sales or growth. The
Tabular Model supports the creation of KPIs that can be used in various client tools.
Getting ready
You need to first create a calculated measure. We will use two new calculations for
this KPI in the
Internet Sales
table. In Measure Grid, create a new measure
in the
Total Product Cost
column, named
Total Cost
. You can do this by
simply clicking on a cell in the column in Measure Grid in the
Total Product Cost
column. Next, use the aggregation shortcut on the toolbar to create a
SUM
measure
and rename the column
Total Cost
.
Once you have
Total Cost
created, you will use
Total Cost
and
Total Sales
created in the previous recipe to create a new measure named
Cost Percent
. In
Measure Grid, click on a cell and add the following expression to the formula bar:
Cost Percent:=[Total Cost] / [Total Sales]
All that is left is to set the format for this new calculation to percentage with two decim-
al places. This will help with the presentation of the new calculation.
Note
As mentioned previously, it is very important that you use good names and format-
ting as you create measures. Consider this as a best practice, and make it a habit
when designing Tabular Models.
How to do it…
Now that we have the supporting measures created, we can add the KPI by perform-
ing the following steps:
Search WWH ::
Custom Search