Databases Reference
In-Depth Information
Adding measures
In tabular models,
measures
are calculations created using DAX formula. Measures
are different from calculated values, which are on a per row basis. Measures are
related to taking slices of data or filtering of data. The
Key Performance Indicator
(
KPI
), although not described in this chapter, is related to measure and you can
create a KPI using measure by creating it in Grid view.
1.
Click a column (the
UnitPrice
column) in the
Order Details
table and
add a measure by clicking
AutoSum
(
Column
|
AutoSum
|
Sum
) as
shown in the next image. Review this link to learn more about measures
here:
http://msdn.microsoft.com/en-us/library/hh230824.aspx
.
Make sure you understand the difference between calculated value and
measure, and the relationship between KPI and measure.
2.
In a similar fashion, add an
AutoSum
to
Product Sales for 1997
.
3.
Click on
File
|
Save
to save the model. It is recommended to save the project.
It is saved to
C:\Users\mysorian\AppData\Local\Temporary Projects\
TabularNW\NW.bim
(default
Model.bim
changed to
NW.bim
using
Save As
).
4.
Click on
Build
. Verify that the build succeeds as seen in the
Output
pane.
Search WWH ::
Custom Search