title: Power Bi: Calculate sum of column value with distinct other column values
body: <p>in power bi I have following table, I want to calculate the total keywords from the table below. Ids are replicating because they are coming from some other Stored Procedure. I want sum to be like this <code>12+13+14</code>.  </p>
  
  <pre><code>Id  Keywords
  A   12
  B   13
  B   13
  B   13
  B   13
  C   14
  C   14
  B   13
  A   12
  C   14
  C   14
  C   14
  C   14
  A   12
  A   12
  B   13
  A   12
  B   13
  A   12
  B   13
  </code></pre>
  
  <p>I tried <code>X = SUMX(FILTER(Query1,DISTINCT(Query1[Id])),[Keywords])</code> and 
  <code>X = CALCULATE(SUM(Query1[Keywords]), FILTER(Query1, DISTINCT(Query1[Id])))</code>
  But nothing is coming.</p>
  
  <p>How this can be done?</p>