Forum Discussion
Count Duplicate Occurences for text fields
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 |
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.
2 Replies
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.
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
