Change column subtotal from average to sum

[Anonymous]

Hi. I just can't figure it out how to make one thing that looks pritty simple, but I still find it difficult to understand. 
Column values "Evening", "Morning", "Night" are averages because I have set it up in the values field. Screen attached:

Also the "Total" column is showing me the average result. But is there any possibility to change it to sum function where it would sum the "Evening", "Morning" and "Night" columns?  Or maybe there is some kind of formula, that could do it for me in the data table? Here is the screen shot of the table:

Basically I need to understand how many  workers worked totally in one day, week or month, just sum up workers of all shifts that day. 

Thank You in advance. 

[kcantor]

@Anonymous 

My reply was going to suggest writing an if statement substituting a Sum for Average if the calculation was not filtered on the row . . . but then @Greg_Deckler  dropped in the perfect reference for you before I typed up this reply.

Greg's reference shows you the basic format. All you need to do is change the calculations to fit your needs and you should be good to go.

[Anonymous]

But I still can't find how I need to change those calculations which Greg has provided that could fit my case. 

[Greg_Deckler]

Sure, check out Matrix Measure Total Triple Threat Rock & Roll for the technique:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...