Martin's Blog

Using calculation groups with role-playing dimensions

The 2019 release of Analysis Services (compatibility level 1500) brought about a new feature called “calculation groups”, which makes it easier to apply the same logic to multiple measures without the need to duplicate code.

In this post we’ll take a look at how calculation groups can be used with role-playing dimensions.

Fixing incorrect drill-through results in Analysis Services – Part 2

The drill-through results in Excel can be incorrect if you’re changing the filter context inside your measure(s). Here’s how you can fix it if you’re using a filter dimension.

Fixing incorrect drill-through results in Analysis Services – Part 1

The drill-through results in Excel can be incorrect if you’re changing the filter context inside your measure(s). Here’s how you can fix it…