Creating measures in DAX is the most important skill necessary to create solid data models. This chapter covers the common functions used to create measures in the data model. It also covers the important topic of data context and how to alter or override the context when creating measures.
After completing this chapter, you will be able to
Understand the difference between measures and attributes.
Understand how context affects measurements.
Create common aggregates.
Know how and when to alter the filter context.
Create KPIs.
Measures vs. Attributes
If you look at a typical star model for a data warehouse, ...
