Excel extras - PowerPivot CALCULATE() with disconnected slicers

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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

Read more...

Tags: dax, design

 

2007-2015 VidasSoft Systems Inc.