title: SSRS created 2 conditional counts and get same result for both
body: <p>I have a very simple SSRS report - a census of employees with health insurance.  I need a count of how many have single policies and how many have family policies.  I created a conditional COUNT statement using the two parameters.  However, they both produce the TOTAL number of policies instead of only the parameter they are supposed to be filtering on.  </p>
  
  <p>Expressions I used:
  =COUNT(IIF(Fields!Deduction.Value = "Single", Fields!Deduction.Value,0))
  =Count(IIF(Fields!Deduction.Value = "Family", Fields!Deduction.Value,0))</p>
  
  <p>I have 79 rows.  54 rows say "Single" and 25 rows say "Family".  The output shows 79 for BOTH groups.</p>
  
  <p>The "Single" and "Family" designation is based on a case statement that converts multiple kinds of policies into the 2 basic values of Single and Family.  </p>
  
  <p>Any ideas on why this is happening?</p>