Creating a calculated measure
One of the great strengths in a model is the ability to create calculated measures and calculated columns. This recipe will cover calculated measures, and the next recipe will discuss calculated columns. However, this is a good place to differentiate between the two.
A good example of a calculated measure would be the sum of sales in our sample model. In this case, we will want to slice the sum by many different values within the model, such as date, customer, and product. A calculated measure will use these values to create a slice of references that are used to get the sum of sales.
One example of a calculated member is a formatted customer name such as Last name, first name. In this case, you need to use the context of the row in the table as part of the calculation because each row will use its values in the calculation. More on calculated columns can be found in the next recipe.
In this recipe, you will learn how to create calculated measures within the model...
