Calculated Groups in Power BI are a powerful feature, available through Tabular Editor, that allow developers to create reusable calculation logic without duplicating measures. Instead of building multiple separate measures for variations such as Year-to-Date, Month-to-Date, or Same Period Last Year, you can define these patterns once inside a calculated group and apply them dynamically across existing measures.
A calculated group contains calculation items, each representing a transformation of the currently selected measure. For example, a “Time Intelligence” calculated group might include calculation items like YTD, QTD, or YoY Growth. When applied, these items adjust the filter context for any measure in the report.
This approach reduces redundancy in the model, improves maintainability, and ensures consistency across measures. It also supports advanced scenarios, such as dynamic currency conversion, scenario analysis, or formatting changes.
However, calculated groups are not yet directly creatable in Power BI Desktop; they require external tools like Tabular Editor. Proper planning is essential, as they can impact how visuals interact with slicers and filters.
In short, calculated groups help Power BI developers streamline their models, enhance flexibility, and maintain cleaner, more efficient semantic layers.