Dynamic Filtered Measure for P&L Reporting

I'm a long-time excel user/modler but a newbie on BI so apolgies in advance. I'm attempting to build out som P&L dashboarding for my company. I have a chart of accounts that I've created naming hierarchies for. So far, they are generically (from higher to lower) Heirarchy 1 / Hierarchy 2 / Account Name. I wanted to create a custom measure to represent margin, i.e. any given filtered layer divided by sales. The following measure did give me the result I wanted, however, it only allows me to filter by Hierarchy 1. I would like to be able to slice and dice by any level of P&L hierarchy and still have it take those results divided by Product Net Sales as defined by Hierarchy 1. Is there a way to do this either directly or indirectly? I assumed it would still work but when I filter for anything but Hierarchy 1, my margin number disappears.

Margin = SUM('Consolidated P&L'[Amount]) / CALCULATE(SUM('Consolidated P&L'[Amount]),'Consolidated P&L'[Hierarchy 1]="Product Net Sales")

 

Also a screen grab of my related filters for context. Idea would be able to filter for lower children of Hierarchy 1 and still have the measure represent that filtered amount over sales i.e. margin %.