title: Common calculated measure across all dimensions
body: <p>I have a cube with 4 dimensions and I have a measure called <code>Transaction Count</code>.  Now I want to calculate the <code>Percentage</code> across all the dimensions for that above measure.</p>
  
  <p>I also have a dimension called <code>Cars</code>. I have the count across all the <code>Cars</code> and now I have defined a calculated measure for calculating the <code>Percentage</code> of each car from the total number of transactions. But it will work only for that particular dimension.</p>
  
  <p>How I can create a single percentage calculated measure which can be used across all the dimensions?</p>
  
  <p>MDX for the calculated measure: (which is working for only Carmake dimension)</p>
  
  <pre><code>CASE
      WHEN ISEMPTY( [MEASURES].[Trans COUNT] ) 
      THEN 0
      ELSE ([Dim Car Make].[Hierarchy].CURRENTMEMBER,
             [MEASURES].[FACT COLORPERFORMANCE COUNT])/
           ( [DIM CAR MAKE].[CARMAKE].[(ALL)].[ALL], 
             [MEASURES].[Trans COUNT])
  END
  </code></pre>
  
  <p>I already have a Trancount(1000) measure. Now I need to create a calculated measure Freq % which should be calculated across all the dimensions.</p>
  
  <p>Screenshot -> <a href="http://i.stack.imgur.com/iuaQO.jpg" rel="nofollow">http://i.stack.imgur.com/iuaQO.jpg</a> (need 10 rep for posting images)</p>
  
  <p>Table 1 in screenshot -  you drag and drop the carmake dimension, then both Tran Count and Freq% should be calculated as per CarMake breakdown.</p>
  
  <p>Table 2 in screenshot - you remove CarMake and drag Quality, then both Tran Count and Freq% should be calculated as per Quality breakdown.</p>
  
  <p>Table 3 in screenshot - you remove Quality and drag Brand, then both Tran Count and Freq% should be calculated as per brand breakdown.</p>