Add Measures

[kemmerrc]

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])

[SpartaBI]

@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]

[kemmerrc]

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

[SpartaBI · Accepted solution]

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