Slicer multiple selection and Cube formulas

Even though you can directly reference the slicer name range in the cube formula, it won’t work if you select multiple slicer values.

But there is a trick I learned thanks to the great PowerPivotPro blog.

Going back to the sheet that holds the PowerPivot table, we had previously selected ‘Calendar Year’ as a vertical slicer.  Interestingly, you can also drag and drop the same field into the report filter field, which in effect enables this field to be both a slicer and a regular filter!