Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Duplicate Value Count

Dear All ,   I want to get the count of the duplicate values as shown below. Below shows my table. Predecessr   FollOn Doc 1030172720   1200261222 1030172740   1200261228 1030172...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    ALLSELECTED has no meaning in a calculated colum.  You can also drop the OrderBy.

     

    Count2 = ROWNUMBER(SUMMARIZE('Table',[Predecessr],[FollOn Doc]),PARTITIONBY([Predecessr]))
lbendlin's avatar
lbendlin
Super User
2 years ago

ALLSELECTED has no meaning in a calculated colum.  You can also drop the OrderBy.

 

Count2 = ROWNUMBER(SUMMARIZE('Table',[Predecessr],[FollOn Doc]),PARTITIONBY([Predecessr]))
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you. This worked for me.