What are common usages of Calculation Groups?

The Calculation Groups feature in Power BI enables you to group common measure expressions into calculation items, which helps significantly reduce the redundancy of measures.

By minimizing the number of measures you need to create and manage, this feature enhances the reusability and maintainability of your reports.

In reporting clients, calculation groups are displayed as a table with a single column. This column represents one or more reusable calculations that can be applied to any measure already added to the Values filter.

Calculation groups work with explicit DAX measures but do not support implicit DAX measures.

To create a calculation group, you can use the Model pane under the Model view or use Tabular Editor. After installing Tabular Editor, you can open your Power BI model, and then create a new calculation group.

Once you have created a calculation group, you must add one or more calculation items. Each calculation item is a measure based on a formula. To add a calculation item, you need to enter a name for the item and a DAX formula.

Usages of Calculation Group

Common uses of “calculation groups” are

1. Reduced measures, especially for Time Intelligence
2. Switching measures, Create a measure Slicer
3. Dynamic format strings
4. Complex table display
5. Measures above column headers