The SSRS report has a CountDistinct in the detail row grouping by Facility. It has a CountDistinct in the total row but it is not the sum of the detail row counts.

For example, the sum of CountDistinct in the detail row is 100 and in the Count Distinct in the total row is 98. I believe if the member went to 2 facilities, the detail rows count as 2 and the total row counts as 1.  How do I sum the CountDistinct in the detail rows?

Thanks.

​The SSRS report has a CountDistinct in the detail row grouping by Facility. It has a CountDistinct in the total row but it is not the sum of the detail row counts. For example, the sum of CountDistinct in the detail row is 100 and in the Count Distinct in the total row is 98. I believe if the member went to 2 facilities, the detail rows count as 2 and the total row counts as 1.  How do I sum the CountDistinct in the detail rows? Thanks.  Read More

​