Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition

© Dan Clark 2017

Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_6

6. Creating Measures with DAX

Dan Clark¹ 

(1)Camp Hill, Pennsylvania, 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.

• Create KPIs.

Measures vs. Attributes

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