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. 

 

"ITEM "IS THE COLUMN I AM USING, "COUNT" IS THE RESULT I NEED FROM DAX/MEASURE

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.

3 Replies

  • 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.