title: SSRS IIF Filtering on Tablix
body: <p>I am working with SSRS and have a tablix that needs certain rows excluded if a value in a multi-value parameter is not selected.  For example, the multi-value parameter is 'Include Loss' and the values are 'Yes' and 'No'.</p>
  
  <p>So if the user selects 'No', then I want the tablix to exclude rows where Description field is equal to the text "Loss Transaction".</p>
  
  <p>I am trying to write an expression to filter on the tablix as follows, but having no luck.</p>
  
  <pre><code>=IIF(Parameters!IncludeLoss.Value="N", Fields!Description.Value, NOTHING)
  </code></pre>
  
  <p>and use '&lt;>' for the 'Operator' and then:</p>
  
  <pre><code>="Loss Transaction"
  </code></pre>
  
  <p>I get the error 'Failed to evaluate the FilterValue of the Tablix'. Any suggestions? Thanks in advance!</p>