Adding a measure to a tabular model
Measures are what your model uses for calculations against the rows and columns based on the formula. Once a measure has been created in the model, users will be able to add it to their reports. For this recipe you will create one measure that counts the number of rows in the CRASH_DATE table. Measures are added to the measure grid area of the grid view in your model.
How to do it...
- Open your project to the CRASH_DATE grid view. You will create the function in the cell highlighted in the following screenshot:
- Left-click on the highlighted cell and enter the following in the function bar
Count_of_Crashs:=COUNT(Crash_Data[CRASH_KEY])
- Press Enter to calculate your function.
How it works...
In this recipe, you entered a DAX formula into the measure grid area that counts the rows. The formula currently shows the total number of rows in your table of 559,227. However, as you continue to add the following recipes, the formula will dynamically count the...
