title: ssrs filter tablix expression that will use parameter value to filter tablix
body: <p>ssrs filter tablix expression that will use parameter value to filter tablix</p>
  
  <p>Id like to filter my tablix based on one parameter with 3 possible values to select from.
              Person
              Dog
              Both</p>
  
  <p>Then filter the tablix by field: Person, Dog, Both...</p>
  
  <p>---update</p>
  
  <p>Tablix Filter by parameter values. Goal include ALL </p>
  
  <p>1 Parameter has 3 options (not multi select). PERSON, DOG, ALL. </p>
  
  <p>I have a field built called FILTER that places "ALL" in the cells. </p>
  
  <p>Otherwise its between the field CLIENT_TYPE "PERSON" or "DOG" </p>
  
  <p>expression:
          Fields!CLIENT_TYPE.Value
  Value<br>
          Parameters!CLIENT_TYPE.Value</p>
  
  <p>This works for "PERSON" and "DOG" only. Dopes Not work for "ALL"</p>
  
  <p>What would be the Expression and Value to filter the tablix according to parameter... </p>
  
  <p>could I trick the "ALL' into excluding nothing? </p>
  
  <p>expression
              IFF(Parameters!CLIENT_TYPE.Value = Fields!CLIENT_TYPE.Value or Parameters!CLIENT_TYPE.Value = Fields!FILTER.Value
                          , "include"
              , "Exclude")</p>
  
  <p>Value
              =Parameters!CLIENT_TYPE.Value</p>
  
  <p>RESOLUTION:</p>
  
  <p>expression</p>
  
  <pre><code>        =(Fields!CLIENT_TYPE.Value = Parameters!CLIENT_TYPE.Value) 
          OR
          (Parameters!CLIENT_TYPE.Value = Fields!FILTER.Value)
  </code></pre>
  
  <p>value
  =true</p>