Display Measures with Custom Hierarchy

[beeehop]

Hello,
I'm working on creating a report with a power pivot table.
We have calculated multiple measures in the main table used in the data model. Pivot and fields pictured here.

Because there are so many regions with metrics shows, I'd like to be able to have a hierarchy in order to collapse down the pivot. I have created a hierarchy but I am unable to figure out how to display each measure in the hierarchy. Any DAX or other solution for the this?

 

[Matt Allington]

This is not easy. You could try using cube formulas (OLAP Tools/convert to formulas) and then manipulate the layout manually. This is probably the easiest. Another approach is to use the asymmetrical table approach I covered here Building a Matrix with Asymmetrical Columns and Rows in Power BI