Powerops
  • Introduction to Powerops
    • Features
    • Use-Cases
    • Advantages
    • Powerops Desktop vs Powerops SaaS
    • Get Started
      • How to Create an Account on GitHub?
      • How to Create an Account on Azure DevOps?
      • How to Create a new Repo in Powerops?
      • How to Register on Powerops?
  • Analyze
    • Overview
      • Importance
      • Features
      • User Interface
    • Summary
    • Report
      • Pages
      • Visuals
      • Custom Visuals
      • Filters
      • Bookmarks
      • Actions
      • Sync Slicers
      • Navigators
    • Model
      • Tables
      • Columns
      • Hierarchies
      • Parameters
      • Data Groups
      • Data Sources
      • Relationships
      • Refresh Policies
      • Perspectives
    • DAX
      • Measures
      • Calculated Columns
      • Calculated Tables
      • Calculation Groups
      • KPIs
      • DAX Query View
      • Visual Calculations
    • Dependencies
      • Model Dependencies
      • Report Dependencies
    • M Queries
    • Roles
      • Row-Level Security (RLS)
      • Object-Level Security (OLS)
    • Info
  • Best Practices
    • Overview
    • Report Rules
      • System Rules (Report)
      • Edit Rules
        • ROM (Report Object Model)
        • Modify Existing Report Rule
        • Create New Report Rule
        • Report Rule Expression
    • Data Model Rules
      • System Rules (Data Model)
      • Edit Rules
        • TOM (Tabular Object Model)
        • Modify Existing Rule
        • Create New Rule
  • Data Security
    • Data Security Review
    • SOC2 Certification
  • INSTALLATION
    • Adding a License Key
  • Release Notes
    • Version 1.0.0
    • Version 1.2.1
    • Version 1.3.0
    • Product Roadmap
  • GENERATE DOCUMENTATION (PRO)
    • Importance of Documenting Power BI Reports
    • Step-by-Step Guide
Powered by GitBook
On this page
  1. Analyze
  2. DAX

Calculation Groups

Last updated 1 year ago

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.