Creating calculated measures
Calculated measures are formulas that do more than simple aggregations of values. These formulas add additional information to the tabular model by creating business calculations. In addition, calculated measures are calculated based on the filter context applied to the data. For example, using a row or column filter in Excel PivotTables or Power View. Depending upon the filters selected, the DAX expression is calculated using the information of the filter in real time. In this recipe, you will use a measure that has the total number of fatal crashes. You will then create a new measure that calculates the total number of crashes minus the number of fatalities.
Getting ready
Follow the steps in the Using Autosum measures in Visual Studio recipe to create the Total Fatalities measure.
How to do it...
On the CRASH_DATA_T table in the Grid view, select an empty cell under the Count_of_Crashes measure.
Enter the calculation in the formula bar:
Total_NonFatal_Crashes...
