Filters CAN Flow Up Hill - Via Formulas That Is

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.