Hierarchy with different values for each level

lbendlin

Hi you helped me yesterday with this post yesterday with hierarchy fields:

https://community.powerbi.com/t5/Desktop/How-to-group-data-further-when-it-has-already-been-grouped/m-p/1222303#M543358.

I closed that question as solved because it solved it for the hierarchy fields.  But looking in more detail today, it gave unintended results, so I am opening a new question here, hoping you or someone else can help.  Even though I am able to group the locations of NY to EB and WB in the matrix now by introducing a new column, where my table looks like this now:

I was averaging the speeds for EB1, EB2, EB3, WB1, WB2 and WB3 from NY.  But by using EB and WB in the columns bucket in the matrix, the speeds are also averaged.  I actually wanted to add the avg speeds of each: For example: 

EB = Avg(EB1 ) + Avg(EB2) + Avg(EB3).  And same goes for WB.  What is the best way to do this?  LA and SF will be fine since they only have two directions. Thanks.