I've used CALCULATE for the purpose of modifying the filter context and sometimes even for context transition.
I have come across an example which I'm not able to make sense of, where in there is a Customer dim, Product dim, Fact Target, Fact Sales. Dims have 1:M relation with Fact tables.
The example that I need help understanding is:
The [Sales Value] measure is doing the SUM of the sales column from FactSales. So how exactly is the SUMMARIZE (which I believe is creating a virtual table) in this example able to pass the filter into the FactSales table? Usually I would imagine the need of something like TREATAS to establish virtual relationship.
