title: Creating advanced SUMIF() calculations in Quicksight
body: <p>I have a couple of joined Athena tables in Quicksight. The data looks something like this:</p>
  
  <pre><code>Ans_Count  | ID   | Alias
  
  10        |  1     |  A
  10        |  1     |  B
  10        |  1     |  C
  20        |  2     |  D
  20        |  2     |  E
  20        |  2     |  F 
  </code></pre>
  
  <p>I want to create a calculated field such that it sums the Ans_Count column based on distinct IDs only. i.e., in the example above the result should be 30.</p>
  
  <p>How do I do that?? Thanks!</p>