title: DAX Query Get Distinct values from Multiple Columns from Multiple Tables
body: <p>I am trying to get my distinct values in DAX from multiple columns originating from multiple tables into one bridge table.</p>
  
  <p>For example, I have Table A and Table B that both have at least the columns Country and City, but only together I get all the distinct values.</p>
  
  <pre><code>Table A
  Country City        Transaction
  US      Washington  A1
  US      New York    A2
  Germany Berlin      A3
  France  Lyon        B1
  US      New York    B2
  Germany Berlin      B3
  France  Lyon        B4
  </code></pre>
  
  <p>And</p>
  
  <pre><code>Table B
  Country City    Transaction
  US      Houston 1   
  France  Paris   2
  France  Paris   3
  Togo    Lome    4
  France  Paris   5
  Togo    Lome    6
  </code></pre>
  
  <p>Together should form:</p>
  
  <pre><code>Table C 
  US      Houston
  US      Washington
  US      New York
  Germany Berlin
  France  Lyon
  France  Paris
  Togo    Lome
  </code></pre>
  
  <p>Any suggestions?</p>