Count(Distinct) Total does not match the detail

[DebraCreed]

I have a report that does a Count(Distinct) on a column that contains an ID.  The lowest level detail for this column is correct.  The total and any other summary totals are not correct.  It is less than the actual value.  The total of the details is 443and not the total shown of 439.  How do I get the total and summary totals to sum to the detail?

[Sean · Accepted solution]

You may have repeating/same LeadIDs in different DistrictIDs

LeadID X counts once overall BUT it will count once within each DistrictID also

so you may have this same LeadID X in District 1 and District 2 and District 3

so it will count once each time on the district level and then again only once overall

Hope this makes sense!

[DebraCreed]

Thank you