Using the AutoSum measure in Visual Studio
It is common when building a new model or enhancing an existing model that you will need to apply formatting onto various columns. Updating the formats in the model prevents users from needing to modify the format each time to access the model. For example, to determine the number of records in a table using a record ID column that is numerical would need to be aggregated with a COUNT function and not a SUM function. This behavior when set at the model level affects how everyone using the model sees the data. When designing your model in Visual Studio, there is an option to quickly apply one of six predefined common functions to numerical columns:
Sum
Average
Count
DistinctCount
Max
Min
This option is very helpful when you need to add calculations on several columns quickly that are numerical data types.
How to do it...
Open the Visual Studio solution for your crash data tabular model.
Select the CRASH_DATA_T table in the Grid View and then scroll to the...
