Power BI Calculation Group subtotals

[DuncanP]

Hi

I'm using calculation groups in Power BI Desktop, but I've found out that subtotals are not displayed (which does make sense as you wouldn't want to add together Current and PY totals for example).

The specific issue I have is that I want a matrix that displays months on the rows, and then categories and a time intelligence calculation group on the columns. I then want to expand the columns at all levels so that you have something like this:

Month	Category A		Category B		Total
	Current	PY	Current	PY	Current	PY
Jan	345	356	857	812	1202	1169
Feb	395	313	837	742	1232	1055
Mar	467	387	859	749	1326	1136
Apr	364	346	794	764	1158	1110

The problem is that in Power BI Desktop, I can't get the last two columns to display. Does anyone know if it's possible, or if there's a workaround somehow?

Duncan

[PierreL69]

Hi I wanted to know if a solution was found ? thanks

[Burtonus]

I ran into this same issue today (3 years later) and managed to find a workaround, which is: more calculation groups. To solve my problem, I just added a new calculation group where each calculation item is 

Item = CALCULATE(SELECTEDMEASURE(),[Category] = "Item")

with one total category which is just

Total = SELECTEDMEASURE() --(or using a CALCULATE() to aggregate specific categories together)

I was then able to add this as well as other calculation groups as different levels of a matrix column hierarchy.

This workaround assumes two things: 1, that you have a manageable number of different categories to work with and 2, that your categories are static enough that you don't need to constantly update the calculation group. It doesn't appear that you can individually format calculation items, so this still won't look like the default Totals column, but at least the numbers are there.

[Anonymous]

Hi @DuncanP,

Have you found a solution by any chance? I am running into the same problem. Calculation Groups work fine, but as soon as I put them in a Matrix as a second column, the totals disappear. Which as you stated makes sense for the individual measures. But for the categories (first column) it does make sense to show the grand total per calculation item.

[Anonymous]

Did you solve this?

[saumitra]

I am facing the same issue. Have you got any solution to this @DuncanP ?

[v-jingzhang]

Hi @DuncanP 

If you are using a Matrix visual, it is easy. In Format pane, under Subtotals, turn on Column subtotals.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[DuncanP]

Hi @v-jingzhang 

Thank you for replying, but unfortunately that doesn't work for calculation groups, and in fact the option is missing altogether!

In my example, Current and PY are two calculation items in a calculation group.

Duncan