cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ozgurozturkkk Frequent Visitor
Frequent Visitor

Summing of groups

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Summing of groups

@ozgurozturkkk,

 

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/219...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Summing of groups

@ozgurozturkkk,

 

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/219...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.