Phoenix Power Platform World Tour has ended
Back To Schedule
Thursday, December 5 • 9:00am - 10:00am
DAX and Filter Context - Seeing the right data

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
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!


Thursday December 5, 2019 9:00am - 10:00am PST
Canyon C