title: How to get Matrix subtotal to the first column in Power BI
body: <p>I have a matrix where different KPI's are coming from different tables
  Example:</p>
  <pre><code>      India   China   USA   Australia  Total
  KPI1  2       3       4     5          14
  KPI2  1       2       3     4          10
  KPI3  8       10      10    8          36
  </code></pre>
  <p>The total column is COLUMN SUBTOTALS to ON in the MATRIX VISUAL and SHOW ON ROW is ON since the data in the base file had to be transposed in order to get this &quot;look&quot;.</p>
  <p>I want to get this column to the front but according to Power BI Community answers, it is currently not possible.</p>
  <p>I was thinking of making a CALCULATED COLUMN or a MEASURE for this task but I don't know how to make it possible since these KPI are coming from different tables.</p>
  <p>Any help on this is very much appreciated or some other workaround?</p>
  <p>EDIT</p>
  <p>SAMPLE DATA</p>
  <pre><code>Teams | Country | KPI 1
      A | India   | 3
  </code></pre>
  <p>in the same way, all KPIs are stored in different sheets of the excel file.</p>
  <p>OUTPUT</p>
  <pre><code>     Total India   China    USA   Australia  
  KPI1  14     2       3       4     5          
  KPI2  10     1       2       3     4          
  KPI3  36     8       10      10    8    
  
    
  </code></pre>