title: POwer pivot Calculated field using aggregates
body: <p>I have a source table loking like this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Measure Name</th>
  <th>Measure value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>01/01/2020</td>
  <td>Revenue</td>
  <td>1250</td>
  </tr>
  <tr>
  <td>01/01/2020</td>
  <td>Sales number</td>
  <td>43</td>
  </tr>
  <tr>
  <td>01/01/2020</td>
  <td>Costs</td>
  <td>1000</td>
  </tr>
  <tr>
  <td>01/02/2020</td>
  <td>Revenue</td>
  <td>4500</td>
  </tr>
  <tr>
  <td>01/02/2020</td>
  <td>Sales number</td>
  <td>590</td>
  </tr>
  <tr>
  <td>01/02/2020</td>
  <td>Costs</td>
  <td>3420</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I create a power pivot table, putting measure name column in ROW field of Power Pivot, which gives the following result :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th>Jan</th>
  <th>Feb</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Revenue</td>
  <td>1250</td>
  <td>4500</td>
  </tr>
  <tr>
  <td>Costs</td>
  <td>1000</td>
  <td>3420</td>
  </tr>
  <tr>
  <td>Sales number</td>
  <td>43</td>
  <td>590</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now I need to calculate Revenue per sale (revenue/sales number). But since revenue and sales number are presented in a single column in source table, they are not available for calculation.
  How can I solve this using DAX? I understand that this could be solved using power query, but that is not a preferred method.</p>