cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
blynchdata
Resolver I
Resolver I

Calculation Group Alternative?

We are currently on SQL Server 2016 SSAS Standard, which does not support Calculation Groups. 

 

We plan to migrate to Power BI Service but until then, are there alternatives to Calculation Groups?

 

Thank you.

2 ACCEPTED SOLUTIONS
d_gosbell
Super User
Super User

The only alternative is to create multiple measures. For example with calculation groups you could create time intelligence items for MTD, QTD and YTD and have a single [Sales] measure. In SSAS 2016 you'd have to create 3 additional measures [Sales MTD], [Sales QTD] and [Sales YTD] 

 

However my suggestion would be to use Tabular Editor (see tabulareditor.com ) to build out these variations that could otherwise be done with calculation groups. One approach is to create all your base measures in a display folder called something like "Current" then you can then either write a script or create a custom action to add time intelligence variations to all the selected measures. I've used this approach in the past to build out a solution with 10+ time intelligence variations and it works really well.

View solution in original post

This was what I figured, but did not consider the scripting. I use Tabular Editor and am just learning about that scripting capability.

 

Thank you for affirming that this is the only alternative until later versions / Online Service and pointing the way via scripting out the measures. 

 

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

The only alternative is to create multiple measures. For example with calculation groups you could create time intelligence items for MTD, QTD and YTD and have a single [Sales] measure. In SSAS 2016 you'd have to create 3 additional measures [Sales MTD], [Sales QTD] and [Sales YTD] 

 

However my suggestion would be to use Tabular Editor (see tabulareditor.com ) to build out these variations that could otherwise be done with calculation groups. One approach is to create all your base measures in a display folder called something like "Current" then you can then either write a script or create a custom action to add time intelligence variations to all the selected measures. I've used this approach in the past to build out a solution with 10+ time intelligence variations and it works really well.

View solution in original post

This was what I figured, but did not consider the scripting. I use Tabular Editor and am just learning about that scripting capability.

 

Thank you for affirming that this is the only alternative until later versions / Online Service and pointing the way via scripting out the measures. 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.