How to add calculation group to Matrix and display Calc Group name above the individual measures.

[effertz12]

I have a bunch of calculation groups, and i would like to have them sub-columned under the name of the calculation group so that when i expand and collapse the rows the Calc group columns move with the measure columns. Is there any way of doing this like how i have it shown in the picture?

[Ritaf1983 · Accepted solution]

Hi @effertz12 

To achieve the specific layout where measures are nested under group headers without redundant columns, you should use a Custom Mapping Table combined with a Dynamic Switch Measure. This approach effectively bypasses the default cross-join behavior of the Power BI Matrix visual.

Solution Overview
Create a Mapping Table: Define a disconnected table with the desired hierarchy:

Group Header: (e.g., Calc Group 1, Calc Group 2)

Measure Label: (e.g., Measure 1, Measure 2)

Sort Order: To ensure correct visual sequence.

Matrix Configuration: Place the Group and Label columns from this table into the Columns field of the Matrix.

Dynamic DAX Measure: Create a single measure using SELECTEDVALUE and SWITCH to return the specific calculation based on the column context in the mapping table.

Detailed Reference in the linked discussion :
https://community.fabric.microsoft.com/t5/Desktop/Remove-Secondary-columns-in-Matrix-Visual/m-p/4923...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-sgandrathi]

Hi @effertz12,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

Thank you.

[v-sgandrathi]

Hi @effertz12,

Thank you @danextian and @Ritaf1983 for your response to the query.

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[danextian · Accepted solution]

Hi @effertz12 

What’s being attempted can’t be done with calculation groups. Calculation groups are meant to apply the same logic across multiple measures, but they don’t allow selectively applying logic to only specific measures and hiding those measures when the logic no longer applies.

For example, Calc Group 1 can’t be applied only to Measures 1–5 and then automatically make those same measures disappear when the selected calculation item is no longer Calc Group 1.

Also, using multiple calculation groups in the same visual will result in a crossjoin between those groups with only the most bottom calc group in the hierarchy being applied.

You'll need a disconnected table which will serve as a display table. This table contains, the grouping, the measure names, sort values and format strings if the measures have different formats. Attached is an application of such an approach.

You display table will kind of look like below:

[Ritaf1983 · Accepted solution]

Hi @effertz12 

To achieve the specific layout where measures are nested under group headers without redundant columns, you should use a Custom Mapping Table combined with a Dynamic Switch Measure. This approach effectively bypasses the default cross-join behavior of the Power BI Matrix visual.

Solution Overview
Create a Mapping Table: Define a disconnected table with the desired hierarchy:

Group Header: (e.g., Calc Group 1, Calc Group 2)

Measure Label: (e.g., Measure 1, Measure 2)

Sort Order: To ensure correct visual sequence.

Matrix Configuration: Place the Group and Label columns from this table into the Columns field of the Matrix.

Dynamic DAX Measure: Create a single measure using SELECTEDVALUE and SWITCH to return the specific calculation based on the column context in the mapping table.

Detailed Reference in the linked discussion :
https://community.fabric.microsoft.com/t5/Desktop/Remove-Secondary-columns-in-Matrix-Visual/m-p/4923...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly