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
kemmerrc
Helper I
Helper I

Add Measures

I need to write a measure to add three measures. I need a total column of Delta Hourly + Delta Exempt + Delta Non-Exempt. I trieed "sum" and "measure" but neither work. Obvisoulsy, I don't know what I am doing. 

Delta Total = measure('Headcount Authorized vs Actual'[Delta Hourly])+measure('Headcount Authorized vs Actual'[Delta Exempt])+measure('Headcount Authorized vs Actual'[Delta Non-Exempt])
Delta Total = sum('Headcount Authorized vs Actual'[Delta Hourly]) + sum('Headcount Authorized vs Actual'[Delta Exempt]) + sum('Headcount Authorized vs Actual'[Delta Non-Exempt])
1 ACCEPTED SOLUTION

@kemmerrc welcome 🙂
Please mark that repsonse as a solution for community visabilty

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@kemmerrc 
Are you trying to create a calculate column or a measure for a report?
If it's a column than just remove all the SUM from your calculation and just keep the column names and plus them:
Delta Total = 'Headcount Authorized vs Actual'[Delta Hourly] + 'Headcount Authorized vs Actual'[Delta Exempt] + 'Headcount Authorized vs Actual'[Delta Non-Exempt]

You are spot on. All I had to do was remove "sum" and it worked. Thank you so very much!!!!!

@kemmerrc welcome 🙂
Please mark that repsonse as a solution for community visabilty

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.