title: power bi: how to establish correct connection between 2 tables
body: <p>I created 2 tables (B and C) from table A. See attached picture:
  <a href="https://i.stack.imgur.com/9av5m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9av5m.png" alt="enter image description here" /></a></p>
  <p>The connection I established:</p>
  <pre><code>'one' in table C: concatenate Name + yr + month (which gives unique values in table C) 
  'to many' in table B
  </code></pre>
  <p>doesn't give me a desirable result.</p>
  <p>When I click a number on the table C (highlighted with yellow), it filters the values in table B.
  But when I click on a number in table B (highlighted with yellow), it doesn't filter.</p>
  <p>Would you help me to left only one row in table C (with information about John) by clicking the number in table B.</p>