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 man...
v-zhangti
Community Support
Community SupportHi, 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.