Anominising data but including duplicated data

[NicPbi]

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

[NicPbi]

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.

[v-zhangti]

Hi, @NicPbi 

Based on the data you provided, what would you expect the output to be?

Best Regards

[v-zhangti]

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.