Matrix removing duplicates (Dates)

[EllaJ234]

Hi, 

I have a set of data which shows the number of bugs a repoter has. The table contains columns for reporters name, the bug ID number and the created date. 

I would like to view this on a matrix like this: The reporter and for each day how many bugs they reported. 

Reporter	01/02/2022	02/02/2022	03/02/2022	04/02/2022	05/02/2022
Joe Bloggs	3	4	2	1	2

Now the issue I have is that when I pull this onto a Matrix instead of getting a box per date I get a box for each instance for each date. So if Joe Bloggs on 01/02/2022 reported 3 bugs I get something like this: 

Reporter	01/02/2022	01/02/2022	01/02/2022
Joe Bloggs	1	1	1

Which okay, if you add them up you get the 3 that were reported. But I do not want to see 3 instances of the item. 

All the dates are in short format so there is no time stamp that could affect this. Also this is all in one table so there is no relationship needed. 

I have also tried to create a separate date table but even when a relationship is determined it does not work. 

Any help would be highly appreciated. Thank you! 

[Anonymous · Accepted solution]

Hi  @EllaJ234 ,

I created some data:

You might consider using a calculated table:

Table 2 =
SUMMARIZE('Table',
'Table'[created date],'Table'[Reporterreporters name],
"Count",COUNT('Table'[ID number]))

Result：

If you need pbix, please click here.

Matrix removing duplicates (Dates).pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[PaulDBrown]

Use a measure for the bugs

Number of Bugs = SUM(Table[Bugs])

[EllaJ234]

Hi Paul, thank you for your reply! 

I tried this & it's still showing the same output. Do you know if there's maybe a grouping feature i'd need to use to pull all the duplicated dates into one date?

[PaulDBrown]

Can you provide sample non-confidential data or PBIX file?