November 2021 Hampton Roads Power BI User Group Meeting

Our next user group meeting will take place on Tuesday, November 16th, 2021.

Topic: Taking DAX to the next level by mastering filter context
Have you ever created a DAX calculation that gave you an answer you didn't expect? Did it use some data from one table but not another, leaving you confused about how it picked? That may have been filter context at work! It's a powerful aspect of Power BI that makes it a great tool, but it can be tough to understand and get right, even if you've been around a while. We will talk about what row and filter context are, how calculate works, and then dig into how to make sure Power BI does exactly what you want the next time you write a CALCULATE statement, including some tips to solve common issues.

Speaker: Ryan McCauley
Ryan McCauley is currently a Senior Data Architect with American Express. He has been in technology for 20 years, and has filled roles from .NET developer and MSSQL DBA to managing an enterprise analytics team (and everything in between). In each role, Ryan is always looking for ways to tackle new and unique challenges. He loves to solve technical problems and get to the bottom of things that don't work, working with others to figure out what could be better and making it happen. Ryan is an MCP and can be found at his website (http://sqlryan.com), on StackOverflow (as SQLRyan), Experts-Exchange (as ryanmccauley), or pitching in to help at the #sqlhelp tag on Twitter (@sqlryan).