topic Add Measures in DAX Commands and Tips

Add Measures

kemmerrc — Wed, 27 Apr 2022 13:31:24 GMT

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

Re: Add Measures

SpartaBI — Wed, 27 Apr 2022 13:36:19 GMT

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]

Re: Add Measures

kemmerrc — Wed, 27 Apr 2022 13:39:23 GMT

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

Re: Add Measures

SpartaBI — Wed, 27 Apr 2022 13:40:24 GMT

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