Calculation Groups

Calculation groups in Power BI are a powerful feature introduced to address the issue of managing and maintaining similar calculations across multiple measures. Calculation groups help you create reusable sets of calculations that can be applied to multiple measures, providing consistency, ease of maintenance, and improved performance.

User Interface

1. Calculation Group Name: Name of the calculation group.

2. Group Descriptions: Comments or notes explaining the purpose, structure, or usage of the calculated group.

3. Is Hidden? It clarifies whether a group is hidden or not.

4. Expression: Formulas which are written to define the logic to generate values for a new calculated group.

5. Group Precedence: The order in which calculation groups are applied to measures.

6. Calculation Item Name: Descriptive label assigned to a specific calculation within that group.

7. Item Description: Explains the calculation

8. Item Ordinal: Set its display order.

9. Format String: Customized how the result would be displayed.