Skip to main content
Submitted

Calculation groups in SSAS Tabular

  • February 27, 2020
  • 5 replies
  • 3 views

Forum|alt.badge.img

Since SQL Server 2019 a new feature called calculation groups has been added. Calculation groups help with the reusability of calculations in models, for example, to simplify time calculations.

5 replies

Forum|alt.badge.img
  • Known Participant
  • June 3, 2020

I feel I need to emphasize how important this is for a mature enterprise solution.  It's very reasonable for someone to want year to date, quarter to date, month to date, previous year, previous month, previous week, year over year, month over month, and week over week - for almost every single measure.  

Without calculation groups, that means that for every measure you want to analyze, you must actually create ten distinct measures.  In other words, not having calculation groups means doing, at minimum, ten times the amount of work for every measure, along with associated problems maintaining those measures.  In addition, you also have to figure out how to display all of those extra measures to the end user.  

I know this is a newer feature in SSAS, but I feel it is a very important one that could easily make the difference between a client choosing to use TimeXtender to build their Tabular models and building their models manually.


Forum|alt.badge.img
  • Participating Frequently
  • August 5, 2020

Calculation Groups are a must have!  We have one model that already has close to 200 measures, and a request just came in to add 190 more for Time Intelligence.

If we were able to create Calculation Groups, we could eliminate over 60% of the measures (Custom DAX) from the model with the creation of a handful of Calculation Items.

 


  • New Participant
  • March 7, 2021

Is there any update on adding this feature? 


  • Participating Frequently
  • June 21, 2021

Hi Andri

 

Thanks for submitting your ideas. Your continued feedback on our product is very important to us. And so is your engagement in our community.

 

Your input has been passed on to our R&D department for further evaluation.

 

At the time of this posting, the current product roadmap is focused on a major evolution in foundational pieces of our software including splitting the development into ODX, MDW, Semantic Layer, and User Portal. With this evolution, we will continue to see incredible innovation in the product that may exceed your expectations or make the need for this feature obsolete.

 

Don't hesitate to let me know if you have any questions or would like to discuss further.

 

Best regards
Mahmoud Ismail


  • Participating Frequently
  • March 31, 2022

Hi all,

to cover requirements similar to calculation groups (before they existed) in enterprise scenarios, I created this script/approach with measure templates and TabularEditor:

https://github.com/datadu-de/MeasureMagic

It can be integrated pretty easily into your CI/CD pipeline for a model and executed against a .bim file but also against a deployed model.