Forum Discussion
Anominising data but including duplicated data
I need to anominise data in a table but some data is repeated numerous times in the same column to report on how many occasions something has happened.
For example, the report created shows how many times a certain Reg number is recorded. Some reg numbers only appear once, many appear multiple times. How do I anonimise the data so the repeated Reg numbers are anonimised in the exact same way so repeat occurances are still reported.
Hope this makes sense & appreciate your help!
| Reg number | Date | Company |
| AA12VYT | 01-Feb | AA |
| BB67HGF | 01-Mar | BB |
| JJ09DSW | 02-Jan | CC |
| RR09WSD | 01-Jun | DD |
| RR09WSD | 09-Jan | EE |
| RR09WSD | 15-Feb | FF |
| RR09WSD | 18-Aug | GG |
| BB67HGF | 31-May | HH |
| BB67HGF | 01-Apr | II |
| BB67HGF | 24-Apr | JJ |
| BB67HGF | 15-Jun | KK |
| BB67HGF | 23-Jul | LL |
3 Replies
v-zhangtiCommunity Support
Hi, NicPbi
You can try the following methods.
Count = CALCULATE(COUNT('Table'[Reg number]),ALLEXCEPT('Table','Table'[Reg number]))Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No unfortunately not as I would want to report on certain reg numbers & how many times they repeated whereas in this instant using counts would have many counts for the same value.
