Column Custom subtotals

[sathishkeshava]

Newbie to PowerBI, I'm trying to do a custom subtotal. Is it possible to do a last two columns.

When I enable row level subtotals for Type, it adds points and marks.

When I enable row level subtotals for Sem or Year, it adds points and marks together for both semesters.

year		2021
Sem		Semester-1		Semester-2
Type		POINTS	MARKS	POINTS	MARKS	POINTS	MARKS
Student1
	MATH	5	90	4	85	9	175
	SCIENCE	6	85	5	80	11	165
Student2
	MATH	4	80	3	75	7	155
	SCIENCE	5	80	4	90	9	170

[v-zhangti · Accepted solution]

Hi, @sathishkeshava 

Your sample data looks like this.

Is this the result you expect? If this doesn't resolve your issue, please let us know more.

Best Regards,

Community Support Team _Charlotte

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

[sathishkeshava]

Sorry, I couldn't get back to you earlier. But the data is in below format. Can you produce same layout using below data ? Thanks