breakdown doesn't match the distinct count

[Maz_0102]

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?

[jdbuchanan71 · Accepted solution]

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_0102]

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?