Make table with filtered totals

[CarlijnM]

Hi,

I hope someone can help. I am building a dashboard, in which I need to sum multiple columns in order to get a total score. I need a total score on 3 different subjects (Interieur, Sanitair and Vloeren).

The data looks something like this:

	Interieur 1	Interieur 2	Interieur 3	Vloeren 1	Vloeren 2	Vloeren 3	Sanitair 1	Sanitair 2	Sanitair 3
1	0	2	1	0	2	1	0	2	1
2	2	0	2	2	0	2	2	0	2
3	6	0	0	6	0	0	6	0	0
4	0	2	5	0	2	5	0	2	5
5	1	6	0	1	6	0	1	6	0

As I did it now, I just summed the columns like [column1]+[column2]=[column3] etc. The problem I am having, is that I want to combine the total scores in 1 table. When I try to do this, I get the following result: 

The problem is, that the total that is calculated in the seperate columns, is shown in every row. So the total for Interieur is also shown behind Sanitair and Vloeren.

What I am looking for is this (this is made as an example):

The total is shown for each category. I want to calculate the total of all columns and rows for Interieur, Sanitair and Vloeren seperately, so 1 total for Interieur, 1 for Sanitair and 1 for Vloeren. 

With the data I have, how can I generate the table above?

[CarlijnM]

Thank you very much! It works now!

Had some issues with measures I already made, but I figured it out.

[amitchandak · Accepted solution]

@CarlijnM , My advice would be to unpivot the table and split the attribute column by delimiter and you will have these values in a row in one column you can create a measure with a filter

https://radacad.com/pivot-and-unpivot-with-power-bi
Split column and Combine Columns: https://youtu.be/T30H_fe2uAA

you only need split part