title: Power Bi Dax create table from other tables
body: <p>Hi I'm pretty new to Power Bi, and am wondering if anyone can help on the issue below? Thanks</p>
  <p>Table &quot;Adviser&quot;</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Adviser_key</th>
  <th>Authority</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>A</td>
  </tr>
  <tr>
  <td>2</td>
  <td>B</td>
  </tr>
  <tr>
  <td>3</td>
  <td>C</td>
  </tr>
  <tr>
  <td>4</td>
  <td>B</td>
  </tr>
  <tr>
  <td>5</td>
  <td>A</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table &quot;Practice&quot;</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Practice_Key</th>
  <th>Adviser_Key</th>
  <th>Practice_group_key</th>
  <th>Practice_group_name</th>
  </tr>
  </thead>
  </table>
  </div>
  <p>How can I use Dax to create a table like below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Practice_Group_Name</th>
  <th>Number_of_adviser_with_Authority_is_A</th>
  <th>Number_of_adviser_with_Authority_is_B</th>
  </tr>
  </thead>
  </table>
  </div>
  <p>The relationship between table &quot;practice&quot; and table &quot;adviser&quot; is Many to One, linked by adviser key</p>