Approximate match with multiple criteria in DAX, part II

On the prior blog entry, I explained how to mix exact and approximate matches when retrieving a value form a lookup table. A solution was explained which required a specific approach that must now be explained. This blog entry goes into more advanced topics related to formula context and some not very intuitive DAX behaviors.

As mentioned here, PowerPivot gives you the ability to mimic the behavior of VLOOKUP with approximate matches. If you must extend the formula to include exact matches, the initial thought is to add more elements to the FILTER function in DAX, as highlighted below: