fbronFrequent Visitor7 years agoSolvedCount 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? Show MoreZunzunUOC7 years agoHi fbron , you could create the next calculated column: num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))Best Regards,MiguelIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ZunzunUOC7 years agoHi fbron , you could create the next calculated column: num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))Best Regards,MiguelIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ZunzunUOC7 years agoHi fbron , you could create the next calculated column: num = CALCULATE(COUNTROWS('Count');FILTER('Count';'Count'[item]=EARLIER('Count'[item])))Best Regards,MiguelIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fbronFrequent Visitor7 years agoMost likely I'm doing something wrong but this doesn't work: Any suggestions?
SNawalKishore1Regular Visitor to fbron7 years agoHello 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 Consultanthttps://www.linkedin.com/in/snawalkishore/
Related contentWorkspace IdentityIdentity Insert On Warehouse tableAuthentication to Sharepoint via Workspace IdentitySecurity of PowerBI - Fixed identity + RLSManaged Identities Security
