SCOPING at different granularities in DAX (Part I)

One of the most powerful MDX functions is SCOPE. With it, one can override cell values at any level of granularity in an SSAS cube and their new custom values will not be considered when returning aggregate results.

It is generally understood you can't use SCOPE-type functionality in an SSAS Tabular model. But if we examine the topic a bit closer, we realize that a lot of what is possible with SCOPE statements can also be replicated with DAX expressions.