Count Duplicate Occurences for text fields

[Anonymous]

Hi, please help in this query wherein i want to count the number of times a value appears row-wise in a separate column "DuplicateCount":-

Should i use measure insted of adding a column?

a shows 2 because it appears 2 times, b shows 3, c shows 4

Value	DuplicateCount
a	2
b	3
c	4
a	2
b	3
c	4
c	4
b	3
c	4

[amitchandak · Accepted solution]

@Anonymous ,

As measure

DuplicateCount= calculate(count(Table[Value]),allexcept(Table[Value]))

or

DuplicateCount= calculate(count(Table[Value]),filter(allselected(Table),Table[Value] =max(Table[Value])))

As a  new column
DuplicateCount= countX(filter(allselected(Table),Table[Value] =earlier(Table[Value])),Table[Value])

Actually no visual will repeat value column unless you have an index column or some other column. so Count(Table[Value]) will also do.

[Pragati11]

Hi @Anonymous ,

Just create a measure as follows:

cntElement = COUNTROWS(yourtablename)

Move this measure to a table visual along with your VALUE column.

Thanks,

Pragati