This session will demystify DAX Filter Context, which determines what portion of your data model a calculation has access to and how you can ensure you have the right data and an accurate result. We'll start with some groundwork on the key concepts involved with DAX, the data formula language used by Power BI and Excel's PowerPivot, including the difference between Row and Filter context, and when you use CALCULATE. We'll spend the bulk of the session with examples of how filters are working, how to modify filters to act on subsets of supersets of your data, and how you can use virtual tables and variables to modify your context. If time allows, we can slip in some DAX editor hotkeys everyone can use whenever they edit DAX to save themselves time and aggravation!
