The expression language in SSRS is a variety of Visual Basic, not T-SQL, so it does not support the BETWEEN comparison operator. You will have to use >= And <=, like this sample:

= CountDistinct(IIf(Fields!ActivityCode.Value >= 50

And Fields!ActivityCode.Value <= 65,

Fields!ApplicationNumber.Value, Nothing))