CALCULATE - Based on value in the data

Hello,

I am new to DAX and Power BI so please bare with me!

I am working with a report that contains many customer survey feedback responses for employees. Each employee is ranked on a score of 1 to 10. The scores are totalled up at the end of each quarter. I'd to create a column that calculates the total score for each employee per Q.

Here is an example that I created in excel. "Employee Total Per Q" is the extra column I would like to create

I looked at the CALCULATE function but that seems to require a specific value to be inputted like "Q3". Is this too complicated for a new column? Is there a better way to do this?

Thanks!