title: Custom tablix filters in SSRS
body: <p>I have a report which displays a table full of raw data. 
  Prior to entering this report, the parent report asks you to select a 'Service' &amp; 'Department'
  Depending on which Service/Department you select from the parent report, this RAW data will be filtered to show the relating data.</p>
  
  <p>Straight forward enough, and it works, great.</p>
  
  <p>I have a new requirement now.
  If the chosen Service is equal to 'Service X' I need the data to be filtered again on that Service, department, but also to add aditional filter, on their 'team'. </p>
  
  <p>so that the data will also be filtered where the team matches the user running the report's team.</p>
  
  <p>I have a dataset already created which returns the user running the reports 'team'
  And also a new parameter called 'team' which defaults to the user running the reports AD number'</p>
  
  <p>The new requirement is, if the <code>Service = X</code>, then filter the data on the department but also on THAT users 'team', if the Service is not equal to X, do nothing.</p>
  
  <p>I think I need to alter the Filters section of the Tablix Properties but am not sure what I need to put in the Expression, Operator, Value</p>
  
  <p>So far I have tried <code>=IIf(Fields!Service.Value = "Service X", Fields!Team.Value, nothing)</code> in the Expression, set the Operator to <code>In</code> and tried filtering on the 'team' from my new dataset which stores the current users 'team' but it is not working.</p>
  
  <p>Does anyone have any suggestions?</p>