Embedding business definitions into DAX measures
In order to drive user adoption and to a foundation to support more analytics it's essential that DAX measures reflect business definitions. These fundamental measures deliver version control across the many reports built off of the model and avoid the need for additional logic to be applied at the report layer. Clear business definitions should be documented and the corresponding measures should be validated for accuracy before report visualizations and analytical measures are developed.
In this recipe measures are created representing business definitions such as sales only for transactions that have shipped. Additionally, role playing measures are created to allow visibility to secondary relationships to a date dimension table.
Getting ready
- Identify the set of base measures to create, the data source to validate against, and the subject matter experts
- Reconcile differences in definitions between source systems and any custom logic applied...
