Database Reference
In-Depth Information
14. Check the Format property for the new measures using the Properties win-
dow on the right-hand side of the model designer. Since the base column
properties were set correctly, you should see the same Format property set-
ting in the measure. If not, you can change it in this window.
Creating calculated measures
It's great that we can define measures to add up a column of numbers, but we
can provide more business value with more specific calculations. We'll start with a
few simple calculations and then introduce DAX functions to add logic and business
rules.
The Calculation Pane, located below the table grid, was designed to emulate an Ex-
cel worksheet. The placement of the current set of measures in the columns below
the base numeric columns is actually just for convenience, and measures can really
be placed in any cell:
1. Select a cell below the Total Product Cost measure and enter the fol-
lowing calculation script. When you get to each measure reference, you can
click on a measure cell or type the open square bracket and then select the
measure name from the list of objects.
Net Cost:=[Total Product Cost] + [Tax
Amt] + [Freight Cost]
Search WWH ::




Custom Search