How to count the number of texts in a columns

[sharpedogs]

This must be  a super easy one for someone to answer. 🙂

I've got a large column with 100,000 account names. I want to count the number of names that contain "RNAB". I've tried so many DAX options but i always get a syntex error. Please help, this easy ask is driving me crazy... 🙂

[az38 · Accepted solution]

Hi @sharpedogs 

try a measure

Measure = CALCULATE(COUNTROWS('Table');ALL('Table');CONTAINSSTRING('Table'[Column];"RNAB"))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn