We are essentially trying to calculate how much revenue is generated per unit filtering it down to a specific branch of a product. Seems like this should be really simple, but ugh. Not really knowing MDX makes it a little difficult 🙂

I tried using something along the lines of IIF(IsLeaf([Dimension].[TopHierarchy].CurrentMember),<do calculation>),sum([Dimension].[TopHierarchy].CurrentMember.Children,[Measures].[MyNewMeasure].

That almost works, but as soon as I try using either Filter or Existing, I get #error :/