Summing of groups

[Anonymous]

Hi all,

I have created 5 groups of some numbers of a specific column("numbers") in one group "function". I did this with the create groups button of Power BI where i choosed the column "numbers".

Example given:

GROUP 1: 5000,6000,7000

GROUP 2: 3000,2000,1000

GROUP 4: 9000,9500,10000

GROUP 5: 15000,2300,55000

Then i created a matrix with the groups on the x-axis and the month's on de y-axisis and the values.

Now the matrix gives a total all the groups, but i want to create some sub-totals.

I want to create something like this

GROUP 1

GROUP 2

SUB-TOTAL OF GROUP 1 and 2

GROUP 3

GROUP 4

GROUP 5

SUB-TOTAL OF GROUP 3, 4 and 5

TOTAL OF GROUP 1,2,3,4 and 5

I hope you guys can help me out.

Regards,

Ozgur

[v-chuncz-msft · Accepted solution]

@Anonymous,

Just add another calculated column and take advantage of drill down.

https://community.powerbi.com/t5/Desktop/Calculated-Column-with-multiple-if-or-or-statements/m-p/219145#M97216