title: PowerBI Total Cost/Unit sums monthly calculations rather than creating a total for selected months
body: <p>In my dashboard I'm adding a cost/unit metric. The problem is, if I select more than one month, it just adds the monthly calculations. For example,</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Store</th>
  <th>Month</th>
  <th>Units</th>
  <th>Cost</th>
  <th>Cost/Unit</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Blue</td>
  <td>Jan</td>
  <td>10</td>
  <td>20</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Blue</td>
  <td>Feb</td>
  <td>20</td>
  <td>60</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Red</td>
  <td>Jan</td>
  <td>10</td>
  <td>30</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Red</td>
  <td>Feb</td>
  <td>20</td>
  <td>80</td>
  <td>4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>When I create a table with with these, and select January and February in the Splicer it shows something like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Store</th>
  <th>Cost/Unit</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Blue</td>
  <td>5</td>
  </tr>
  <tr>
  <td>Red</td>
  <td>7</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Of course this isn't the real total cost/unit for both months. Instead I'd like for it to show:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Store</th>
  <th>Cost/Unit</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Blue</td>
  <td>2.67</td>
  </tr>
  <tr>
  <td>Red</td>
  <td>3.67</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I am pretty new to PowerBI so I'm sorry for the lack of words on how to explain this, but help would be very much appreciated!</p>