SCOPING at different granularities (Part III)

In the last two blog entries on this topic (available here and here), we got a bit closer to reproducing - in DAX - the same output one would normally achieve with the MDX scope statement.

In this new entry, we perfect the formula a bit more by ensuring filter context propagates to the higher levels of granularity we are affecting.