Total sum of Row values (not automatic total)

[Anonymous]

Good morning everyone,

I have a visual in which I have calculated bonuses for some employees based on reached or unreached goals. I have on the rows the employee and on the columns the different weeks of the month. Since objectives are weekly i calculate a specific amount of bonus for each week and i woul like to have a final column that sums up the values of the bonus for each employee. Obviuosly the total column of Power BI doesn't do that, and i'm struggling to find a way to do it. 

Thank you for your help

(I covered the employee names for privacy)

[ValtteriN]

Hi,

Try a measure like this:

CALCULATE(SUM('Table'[Bonus]),ALLEXCEPT(Table,Table[Employee]))
This will remove the filter context except for the employee. You might need a year in addition to this. So just in case: 

var _year = MAX('Calendar'[Year]) return
CALCULATE(SUM('Table'[Bonus]),ALLEXCEPT(Table,Table[Employee]),Table[Year]=_year)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!