Excel extras - PowerPivot CALCULATE() with disconnected slicers

Last month's article went back to PowerPivot basics and examined the CALCULATE() function in more detail, showing how filters can be applied to your dataset to return different results in relation to a number of factors and user selections. This month, we'll enhance this capability with some more advanced concepts, one of which is the concept of disconnect slicers.

A quick overview of filtering
Let's refresh our minds on the syntax for the CALCULATE() function