Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

© Dan Clark 2020

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

6. Creating Measures with DAX

Dan Clark¹ 

(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 ...