CALCULATE - Based on value in the data

[Jake__789456]

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!

[Jake__789456]

Thank you @wdx223_Daniel!

Your solution worked, I'm not sure I understand exactly why but thank you all the same! 😉

[wdx223_Daniel · Accepted solution]

in calculated column, use this code

=calculate(sum(table[survey score]),allexcept(table,table[employee],table[Q+Year]))