Count identical values within a column

[fbron]

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? 

[ZunzunUOC · Accepted solution]

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]

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

Any suggestions?

[SNawalKishore1]

Hello @fbron ,

Solution suggested by @ZunzunUOC is to create DAX Column in Power BI Desktop 🙂 . Not Custom Column in Power Query editor. 

Cheers,

Nawal
+91-9866755720 | Power BI Consultant

https://www.linkedin.com/in/snawalkishore/