title: SSAS 2012 Calculated Member for Percentage
body: <p>Being an SSAS newbie, I was wondering if it's possible to create a calculated member that references an individual row's value as well as the aggregated value in order to create a percentage?</p>
  
  <p>For example, if I have a fact table with ValueA, I'd like to create a calculate member that essentially performed:</p>
  
  <p><strong>[Measures].[ValueA]</strong> <em>(for each row I've sliced the data by)</em> <strong>/ [Measures].[ValueA]</strong> <em>(the total)</em></p>
  
  <p>Also I'd like to keep the total as the sum of whatever's been filtered in the cube browser. I feel certain this must be possible but I'm clearly missing something.</p>