Creating calculation groups
Calculation groups are new to tabular models. You can only use this functionality if your model is set to Compatibility Level = 1500. Now, why is this important? As tabular models become more prevalent, we see more and more calculations being added to models. Many times, users grab a common set of calculations in various settings. For example, we created YTD, next year, and previous year measures for Invoice Sales.
If you want to do the same calculations for Invoice Profit, you will need to create new measures to support this. With calculation groups, you can create a group of metrics that work with various measures. We could use a calculation group to create the time intelligence calculations that can be shared across measures.
Getting ready to create calculation groups
Before we create our calculation group, we need to make sure our measures and model are ready. First, this functionality only works with explicit measures. Explicit measures are...
