title: PBI Measure as a Value in Matrix Visual
body: <p>I appreciate some help with the below problem.
  I have the table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Month</th>
  <th>Line</th>
  <th>Amount</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Jan</td>
  <td>ST</td>
  <td>20</td>
  </tr>
  <tr>
  <td>Jan</td>
  <td>AB</td>
  <td>10</td>
  </tr>
  <tr>
  <td>Jan</td>
  <td>AC</td>
  <td>2</td>
  </tr>
  <tr>
  <td>Jan</td>
  <td>AG</td>
  <td>15</td>
  </tr>
  <tr>
  <td>Feb</td>
  <td>ST</td>
  <td>40</td>
  </tr>
  <tr>
  <td>Feb</td>
  <td>AB</td>
  <td>20</td>
  </tr>
  <tr>
  <td>Feb</td>
  <td>AC</td>
  <td>4</td>
  </tr>
  <tr>
  <td>Feb</td>
  <td>AG</td>
  <td>8</td>
  </tr>
  <tr>
  <td>Mar</td>
  <td>ST</td>
  <td>65</td>
  </tr>
  <tr>
  <td>Mar</td>
  <td>AB</td>
  <td>5</td>
  </tr>
  <tr>
  <td>Mar</td>
  <td>AC</td>
  <td>6</td>
  </tr>
  <tr>
  <td>Mar</td>
  <td>AG</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>and I want a Matrix</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th style="text-align: center;">Jan</th>
  <th style="text-align: right;">Feb</th>
  <th style="text-align: right;">Mar</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>AB</td>
  <td style="text-align: center;">50.00%</td>
  <td style="text-align: right;">50.00%</td>
  <td style="text-align: right;">7.69%</td>
  </tr>
  <tr>
  <td>AC</td>
  <td style="text-align: center;">10.00%</td>
  <td style="text-align: right;">10.00%</td>
  <td style="text-align: right;">9.23%</td>
  </tr>
  <tr>
  <td>AG</td>
  <td style="text-align: center;">75.00%</td>
  <td style="text-align: right;">20.00%</td>
  <td style="text-align: right;">3.08%</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The Value of the Matrix is a Mesure</p>
  <pre><code>(%) Amount ST =
  SWITCH (
      TRUE (),
      SELECTEDVALUE ( table1[Line] ) = &quot;AB&quot;,
          DIVIDE (
              SUM ( table1[Amount] ),
              CALCULATE ( SUM ( table1[Amount] ), FILTER ( 'table1', table1[Line] = &quot;ST&quot; ) )
          ),
      SELECTEDVALUE ( table1[Line] ) = &quot;AC&quot;,
          DIVIDE (
              SUM ( table1[Amount] ),
              CALCULATE ( SUM ( table1[Amount] ), FILTER ( 'table1', table1[Line] = &quot;ST&quot; ) )
          ),
      SELECTEDVALUE ( table1[Line] ) = &quot;AG&quot;, DIVIDE ( SUM ( table1[Amount] ), 4 ),
      SUM ( table1[Amount] )
  )
  
  </code></pre>
  <p>The measure works fine for AG, to test it I used in the denominator the number 4, but when I added the calculate function to filter by ST I didn't see it in the visual ???</p>
  <p>Any ideas</p>
  <p>Thank you
  OJ</p>