title: CountDistinct coming out with wrong calculation
body: <p>So I'm trying to count the amount of fields (called [Emergency]) that are both true and false to multiply by the standard price of either a regular or emergency booking.</p>
  
  <p>Currently this is only working for the emergency revenue calculation(looks like this):</p>
  
  <pre><code>=CountDistinct(Fields!Emergency.Value = True) * 3.0
  </code></pre>
  
  <p>And lets say there are two records with the emergency field being true, since the price of an emergency booking is £3.00, it outputs as £6.00 total</p>
  
  <p>While the regular revenue calculation looks like this:</p>
  
  <pre><code>=CountDistinct(Fields!Emergency.Value = False) * 1.5
  </code></pre>
  
  <p>The output of this with four records having the emergency field being false and the price of a regular booking being £1.50 is £3.00, while the expected output should be £6.00</p>
  
  <p>I'm not sure what is causing this problem as it's my first time using SSRS</p>