© Philip Seamark 2018
Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_3

3. Context

Philip Seamark1 
(1)
UPPER HUTT, New Zealand
 

Some say that once you have mastered the concept of context in DAX, you have mastered DAX. This is mostly true, and if you have indeed mastered context, you are a long way up the learning curve.

Context can seem a little daunting at first, but once you understand the effect that types of context have on calculations, hopefully DAX starts to make more sense. Context is how DAX applies layers of filtering to tables used in your calculations so that they return results that are relevant for every value.

Most context is automatic, but some context allows you to control the underlying data passed ...

Get Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence 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.