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

2. Press Enter to validate the expression and save the changes.
3. With the new measure cell selected, use the Properties window to set the
Format property to Currency .
4. Select the cell to the right, and enter this expression to define a calculation
named Net Profit . You will also format this measure as Currency .
Net Profit:=[Sales Amount] - [Net Cost]
5. In the next cell, define a calculated measure named Net Margin .
Net Margin:=[Net Profit] / [Sales Amount]
This expression produces a ratio value that we want to format as a percent-
age.
6. After writing the expression, set the Format property to Percent and the
Number of Decimal Places field to the value 2 .