In development: Reuse BI calculations with calculation groups in Azure Analysis Services

Posted on Friday, April 26, 2019

Calculation groups in the Azure Analysis Services tabular engine address the issue of proliferation of measures in complex BI models often caused by common calculations like time intelligence.

Enterprise models are reused throughout large organizations, so they grow in scale and complexity. With calculation groups, you can reduce the number of measures and present an uncluttered interface to users. Users simply select calculation groups in the field list to view the calculations in Power BI visuals. There's no need for a user or modeler to create separate measures.

This feature is already in public preview in CTP 2.3 of SQL Server Analysis Services 2019. We plan to officially launch it in Azure Analysis Services soon.