Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
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!
Proud to be a Super User!
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |