Reply
Maz_0102
Helper I
Helper I
Partially syndicated - Outbound

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?

 

Maz_0102_0-1647275845536.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Syndicated - Outbound

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.

View solution in original post

3 REPLIES 3
jdbuchanan71
Super User
Super User

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

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.

Syndicated - Outbound

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?

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)