Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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!
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!
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |