Intro from Rob
Many of you already know of Matt Allington and his background as BI Director for Coca-Cola Asia Pacific. Matt recently flew around the world (literally) to attend my training course with the purpose of becoming accredited by me as the official PowerPivotPro University Trainer for Australia (we even have a picture to prove it – displayed at right).
Now that Matt has my approval to teach my material, I have invited Matt to be a regular blogger on PowerPivotPro.com. This is Matt’s first post in this capacity, so over to you Matt.
Confessions of a DAX student
Matt here: I want to share with you a simple mistake I made early on in my DAX journey, and also create awareness of how easy it is to fall into a similar trap. This post will explain the mistake and provide the solution to how you can get filters to flow up hill – via formulae that is.
If you learnt DAX the Rob Collie way (like I did) you would be very familiar with Rob’s best practice of placing the lookup tables above the data tables in the PowerPivot Diagram View.
The reason Rob teaches it this way is because it is very easy for the reader to visualise the flow of a filtered table – filters flow down hill.