title: Remove duplicates in summarize table
body: <p>I want to remove duplicate rows of a union of two tables using DAX. </p>
  
  <p>This is my code:</p>
  
  <pre><code>Global = 
  VAR Table1= SUMMARIZE(GLAccounts;GLAccounts[AccountID];GLAccounts[AccountDescription];GLAccounts[Name];GLAccounts[GroupingCode];GLAccounts[ChaveConta])
  Var Table2= SUMMARIZE(GLEntries;GLEntries[AccountID];GLEntries[AccountDescription];GLEntries[Name];GLEntries[GroupingCode];GLEntries[ChaveConta])
  RETURN
  UNION(Table1;Table2)
  </code></pre>
  
  <p>I know if I create another summarize table over this one, I'll remove the duplicates, but isn't there a way to do the whole thing in a single table?</p>
  
  <p>Thanks for helping!</p>