Forum Discussion
Helper Ibreakdown 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?
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.
3 Replies
- jdbuchanan71
Super User
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.
- jdbuchanan71
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.
Maz_0102thank 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?