The PASS Business Analytics Group provides virtual training on the tools and architecture patterns required to create world-class Business Analytics solutions.

Sign in to Subscribe

News and Updates

Join us today - become a member of the Business Analytics Virtual Group.

Sign up for a free PASS membership and choose the option to join the BA Virtual Group in the myPASS portal. We'll keep you posted of all upcoming meetings, learning opportunities and the latest and greatest info from Microsoft.

Interested in speaking at an upcoming BA VG webinar?

Send us your information by completing the Call for Speaker survey here and we will follow up with you or you can contact us today to let us know by email using


Working with complicated data models in DAX

Thu, Jan 17 2019 19:00 UTC

Working with complicated data models in DAX

Have you ever watched a demo of DAX functionality, and marvelled at how simple the language is, but yet, when you work on your own data model, it just doesn't work as expected? In this session, we'll look at 4 common problems which occur when you're using more complicated data modelling techniques, and design and implement a simple solution to overcome these complications. From role-playing dimensions and bi-directional filters to advanced filter context and overriding the default blank behaviour, we'll learn to solve a variety of problems and add value to our data models.

James McGillivray

James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at a number of SQLSaturdays in South Africa and abroad. At SQLSaturday Los Angeles 2017, two of James' talks were voted in the top 5 talks for the day.

Follow us on Twitter: @PASSBAVC | Contact us: PASSBAVC@SQLPASS.ORG
Back to Top