Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Total sum of Row values (not automatic total)

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)

filippodea_1-1643191778945.png

 

 

1 REPLY 1
ValtteriN
Super User
Super User

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!






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.