title: DAX Query to Get Distinct Items from Multiple Tables
body: <h2>Problem</h2>
  
  <p>I'm trying to generate a table of distinct email addresses from multiple source tables. However, with the <code>UNION</code> statement on the outer part of the statement, it isn't generating a truly distinct list.</p>
  
  <h2>Code</h2>
  
  <pre><code>Participants = UNION(DISTINCT('Registrations'[Email Address]), DISTINCT( 'EnteredTickets'[Email]))
  </code></pre>
  
  <p>*Note that while I'm starting with just two source tables, I need to expand this to 3 or 4 by the end of it.</p>