title: Calculating Percent of Total in Power Pivot Model
body: <p>I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales change. For which I have to divide for example corporate family <code>"Acer"</code> 's sales in <code>2012Q4</code> by sum of all the corporate family. I am using calculated measure to do this, but I am not sure what formula I can use.</p>
  
  <p><img src="https://i.stack.imgur.com/vCg85.png" alt="enter image description here"> </p>
  
  <p>My need is to create two columns, one for <code>2012Q4</code> percent of total and one for <code>2013Q1</code> percent of total. Then I will create another measure to find the difference. So the formula for <code>2012Q4</code> should be like this <code>1624442 / (1624442+22449+1200+16123)</code> . Any idea which function can help me do it?</p>