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.
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.
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…
Hi, I’m Martin. I like to help people make sense of their data, using Microsoft technologies. This blog is my attempt at giving back to our awesome community, from which I have received so much. Hope you find it worth reading!
Subscribe to My Blog
Get new content delivered directly to your inbox.
Administration Analysis Services Biml Business Intelligence Calculated Measures Career Data Warehouse Architecture DB2 Drivers Dimensional Modeling Drill-Through Results ETL Events Feature Packs General iif-function Internet Explorer 9 MDX Multidimensional O365 OLEDB Drivers Parameter Sniffing PASS PASS Summit Performance Power BI PowerShell Presentations Report Builder 3.0 Reporting Services Scoped Assignment SetToStr Function SharePoint 2010 SQL Saturday SQL Saturday SQL Server SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SSAS 2008 R2 SSIS SSRS 2008 R2 SSRS 2012 T-SQL Tabular Temporal Fact Table