Subtotal for tutor hours by student by six weeks sessions

[Anonymous]

Hello Power BI Super users,

I have this table below. Is there a DAX that will create a new table to show the following? 1st, 2nd, 3rd Six Week Session is outputted by create a group. 

I want to have total hours by student id by session weeks (groups). I imagine the table below helping me to output a cluster column chart. 

Is there a DAX that will create a new table to show the following? 

Student ID	Session	Totals Hours
78540	1st Six Weeks	3.0
78540	2nd Six Weeks	8.0
78540	3rd Six Weeks	5.5

I appreciate the nudge.

Luis

[Anonymous · Accepted solution]

I figured out the solution.

I needed a measure and a table.

Step 1.

Total Tutoring Hours = SUM('Tutorial Log_Long'[30-minute Sessions])*.5

Step 2. 

Tutor Hours by Sessions =

SUMMARIZE(

    'Tutorial Log_Long', 'Tutorial Log_Long'[Student ID], 'Tutorial Log_Long'[Sessions Weeks (groups)], "Total Tutor Hours", 'Tutorial Log_Long'[Total Tutoring Hours])

Step 3. Bring in Session Weeks (Group) into the filters

Thank you to everyone. I appreciate the nudges.