Question: Is it possible to segment calculated groups based on categories?

Hi  Anonymous , 

Thank you for raising this query.

Currently, Power BI Desktop does not support the direct creation or editing of calculation groups. To work with calculation groups  including the addition of calculated columns, you’ll need to use an external tool such as Tabular Editor.

Once your model is open in Tabular Editor, you can add calculated columns to a calculation group table just like you would with any standard table. As mentioned by OwenAuger, these columns can be useful for grouping or filtering calculation items in report visuals. For example, you might categorize items as "Year Analysis" or "Month Analysis" to make navigation easier for report users.It's important to remember that calculation group tables are not designed to support relationships with other tables in your model. Their main purpose is to dynamically modify measure behavior, not to function as regular dimension or lookup tables.

If this helps, kindly click "Accept as Solution" and give a "Kudos" so others can benefit. Let me know if you need further assistance!

Thank you,

Tejaswi.