title: SSRS Count on expression doesn't work on Matrix
body: <p>I have setup a Matrix and use &quot;Add total&quot; to create a new column to show the total number in SSRS. Then I created another new column on the right with expression Replace the number in Add Total column with Text. However, when I use Count expression to count this new text column contain &quot;Passed&quot; and &quot;Not Passed&quot;, it shows the total count without filtering.  I have tried different expression, it shows either the total count or 0.  I am getting confuse if I should be using =Count(Fields!xxx.Value = &quot;Passed&quot;) OR =Count(Parameters!xxx.value = &quot;Passed&quot; ?</p>
  <p>I have looked thru different example on this website but didn't seem to find a resolution, or it's the Matrix is created incorrectly ? Hope someone can provide some help. Million thanks.</p>
  <p>Zoma</p>