Compute average number of rows per group in Sql Server Reporting Services

Question

I have a table widget in reporting services where I group rows on a given id.

For each group, I display the number of rows per group, using countrows().

How can I display the average number of rows per group at the end of my report ?

What I am missing is : how to count the number of groups?

Answer 1

This is from memory - not sure if this expression is correct:

= Count(Fields!ID.Value) / CountDistinct(Fields!ID.Value)

Assuming that the "ID" you're grouping by is a single field, that sort of expression should get you what you want.