© Dan Clark 2020
D. ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_6

6. Creating Measures with DAX

Dan Clark1 
(1)
Camp Hill, PA, USA
 

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

Measures vs. Attributes

If you look at a typical star model for a data warehouse, you ...

Get Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.