Forum Discussion

fbron's avatar
fbron
Frequent Visitor
7 years ago
Solved

Count identical values within a column

I'd like to count the amount of identical values within a column and present the outcome within a new column.    Any suggestions? 
Need Help
Show and Tell
Tips and Tricks
  • ZunzunUOC's avatar
    ZunzunUOC
    7 years ago

    Hi fbron , you could create the next calculated column:

     

    num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))

    Best Regards,
    Miguel

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

Hi fbron , you could create the next calculated column:

 

num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • fbron's avatar
    fbron
    Frequent Visitor
    7 years ago

    Most likely I'm doing something wrong but this doesn't work:

     

     

    Any suggestions?