Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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
    3 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]))
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 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]))
  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    that's right, I write everything out of habit

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you. This worked for me.