Forum Discussion
Helper ICountifs to identify duplicates in dataset
hello adbm
there are couple ways to do this depend on what/how you want to show those data.
but in order to check duplicate, here are some ways.
1. using table visual. just drop your column value and this visual will automatically show one value per same value.
2. use measure. as you can see, the duplicate value will be indicated by value over than 1.
Duplicate =
var _Vendor = SELECTEDVALUE('Table'[Vendor ID.#])
var _Dupl = CALCULATE(COUNT('Table'[Vendor ID.#]),ALLSELECTED('Table'),'Table'[Vendor ID.#]=_Vendor)
Return
_Dupl3. use calculated column. Similarly to measure above, but using calculated column (one with EARLIER() and another without EARLIER()).
Hope this will help.
Thank you.
Super Userhello adbm
there are couple ways to do this depend on what/how you want to show those data.
but in order to check duplicate, here are some ways.
1. using table visual. just drop your column value and this visual will automatically show one value per same value.
2. use measure. as you can see, the duplicate value will be indicated by value over than 1.
Duplicate =
var _Vendor = SELECTEDVALUE('Table'[Vendor ID.#])
var _Dupl = CALCULATE(COUNT('Table'[Vendor ID.#]),ALLSELECTED('Table'),'Table'[Vendor ID.#]=_Vendor)
Return
_Dupl
3. use calculated column. Similarly to measure above, but using calculated column (one with EARLIER() and another without EARLIER()).
Hope this will help.
Thank you.
Helper IHi Irwan,
Thanks for that.
Solution 1 is easier but i want to be able to see the rows that are repeated so i need to see the count over 1. Solution number 2 didnt seem to work. Solution 3 with earlier worked for me. I used a calculated column as suggested by you with countrows and earlier and that seemed to work for me.
Thanks for all your help!
Best,
Natali