DAX Calculations and Queries - SQL Server Analysis Services 2012 Cube Development - page 375

gives the measure a name such as Sum of Sales Amount . This is a good way to
get started with creating measures, but you may not want to have every measure in
your model begin with the text Sum of .

Working with a measure table that contains numeric columns, you will hide the base
columns, create calculated measures, and apply formatting properties:

1. Select the Internet Sales table in grid view.
2. Select all of the key columns (the first eight columns whose names end with
the word Key ) and hide them. You can use the Shift key to click on and select
a range of columns.
3. Right-click on the selected range and then click on Hide from Client Tools .
4. I'll show you a trick that will save time when using the AutoSum feature to
create measures. Select each of the following columns and use the Proper-
ties window to set the Format property as indicated in the following table:

Column Name Format Property

OrderQuantity Data Format: Whole Number

Show Thousand Separator: True

UnitPrice Currency

ExtendedAmount Currency

UnitPriceDiscountPct Currency

DiscountAmount Currency