rdlc CountDistinct where status = 1

Question

I would like to count distinct values from dataset with where condition.

This is as far as i did:

CountDistinct(IIF(Fields!Status.Value = 1, Count(Fields!Id.Value),nothing))

Or

IIF(Fields!Status.Value = 1, Count(Fields!Id.Value),nothing)

but it doesnt work.

Answer 1

sum(IIF(Fields!Status.Value = 1, 1,0)