Hierarchy with different values for each level

[wpf_]

@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/...

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. 

[mwegener]

Hi @wpf_ ,

was your problem solved?

[wpf_]

Yes i will close this. Thanks. 

[amitchandak]

@wpf_ , refer if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Can you share sample data and sample output in table format?

[wpf_]

@amitchandak 

I have created a sample pbix file in one drive.  Here is the link:  

https://1drv.ms/u/s!AkwCuDVUJER4gR6003JMfSUgPfls?e=BrECoU

Thanks.