- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

breakdown doesn't match the distinct count
Hi
when i click on whiteley B 99 on 28/02 as an example, i have an another table which shows the list of data for that specific count summary but it shows more rows than 99
can anyone advise please?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

If you want the total row to add up to the breakdown by site you can use a meaure like this.
Distinct Count Good Total =
SUMX ( VALUES ( 'Your Table'[Site] ), DISTINCTCOUNT ( 'Your Table'[User Name] ) )
You will have to change the table and field names to match youor model.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

If you want the total row to add up to the breakdown by site you can use a meaure like this.
Distinct Count Good Total =
SUMX ( VALUES ( 'Your Table'[Site] ), DISTINCTCOUNT ( 'Your Table'[User Name] ) )
You will have to change the table and field names to match youor model.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

When doing a distinct count, if you have any items that can appear in more than one category (site) they will only get counted once in the total so the total will be lower than the sum of the breakdown.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

thank for your response
the issue im having is i have data which has a lot of duplictates eg uesrs against dates
im trying to remove these duplicates but i cant get the accurate count
whats the best way if you can advise?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-29-2024 02:03 AM | |||
01-16-2025 07:51 AM | |||
08-13-2024 09:40 AM | |||
12-10-2024 11:59 PM | |||
10-07-2024 10:50 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |