How to average each sub category then sum them?

[wpf_]

I have a matrix that shows the time it takes cars to go from point A to point B at a certain location.  It shows the average speed of each hour (0 - 23) for that month.  

LA

But the problem is for certain locations (NY), it needs to add up each link ( avg(EB1) + avg(EB2) + avg(EB3) ) to make one virtual link that will show the a time to take to go that distance for that hour. 

So in the matrix it is showing the average of all 3 links, and not the sum of all three:

NY

Here is a link to my pbix sample in onedrive. Thanks.

https://1drv.ms/u/s!AkwCuDVUJER4gR-2qe6msJKTvv3u?e=XVxJFT

[Greg_Deckler]

@wpf_ - So, you will want to use a measure and utilize SUMMARIZE or GROUPBY to group the data the way you want do your sums or averages. If you need to, you can use SUMX/AVERAGEX across that table. Not exactly sure I understand what you are going for exactly.

[wpf_]

Hi @Greg_Deckler 

Thanks for responding.  I guess a better way to explain it is if I have a hierarchy (virtual travel time > individual travel time links).  And I put the hierarchy in the columns bucket in a matrix.  If I drill down to the individual travel time links, it shows the avg time per link.  But If i drill up to virtual travel time, it should give me the sum of each individual link.  Currently, virtual travel time is giving me the avg of the individual travel time links.  I provided a link to my pbix file, it might be easier to understand from there.  Hope you can help. Thanks. 

[Greg_Deckler]

@wpf_ - OK, maybe take a look at MM3TR&R - https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

Basically, shows how to do different aggregations at different levels of a matrix.

Also the more general technique in dealing with measure totals, is this Quick Measure, Measure Totals, The Final Word:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[wpf_]

@Greg_Deckler ,

Thanks i was able to get another measure to sum the measure that averages.