title: Count and sum unique Values POwer BI
body: <p>I'm trying to get the sum of Sales with uniuqe Catatery i'm using DAX Formula below </p>
  
  <pre><code>Countoracle = CALCULATE(SUM('Data Source'[Sales) ,DISTINCTCOUNT ('Data Source'[ItemAr]))
  </code></pre>
  
  <p>getting error </p>
  
  <blockquote>
    <p>The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.</p>
  </blockquote>