This chapter will detail the implementation of DAX measures and security roles for the dataset developed in the previous two chapters. First, a set of base measures for each business process are created, representing business definitions such as gross and net sales, cost of sales, and margin percentages. The base measures are then leveraged in the development of date intelligence calculations including year-to-date (YTD) and year-over-year (YOY) growth. Additionally, a set of customs measures are created, including exceptions, rankings, and KPI targets to further extract insights from the dataset and simplify report visualizations.
This chapter will also contain examples of dynamic security models in which the identity of the logged in user is used to filter the dataset. Finally, guidance will be provided on testing the performance of DAX expressions with DAX Studio.
In this chapter, we will review the following topics:
- DAX measures
- Filter and row contexts
- DAX variables
- Base measures
- Date intelligence metrics
- Dimension metrics
- Ranking metrics
- Security roles
- Dynamic row-level security
- Performance testing