Forum Discussion
Matrix removing duplicates (Dates)
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!
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
4 Replies
Use a measure for the bugs
Number of Bugs = SUM(Table[Bugs])
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?
Can you provide sample non-confidential data or PBIX file?
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
