How Count cells with specific Text in certain column

[Anonymous]

Dears

AM trying to count cells with specific text inside it

i have project column and i want to count cells that contains specifc word which is "enhancement" inside this cell in spesific column

thanx

[amitchandak · Accepted solution]

@Anonymous , You can use

https://docs.microsoft.com/en-us/dax/containsstring-function-dax

calculate(count([Names]),CONTAINSSTRING([Names],"enhancement"))

or

https://docs.microsoft.com/en-us/dax/search-function-dax

https://docs.microsoft.com/en-us/dax/find-function-dax

[Anonymous]

both solutions working for me

thanx 

[mahoneypat · Accepted solution]

You can try this approach

Projects with Enhancement = COUNTROWS(Filter(Table, SEARCH("Enhancement", Table[Project], , 0)>0))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[mohitsati-9953]

Thanks for the solution, But it count the header also?

[amitchandak · Accepted solution]

@Anonymous , You can use

https://docs.microsoft.com/en-us/dax/containsstring-function-dax

calculate(count([Names]),CONTAINSSTRING([Names],"enhancement"))

or

https://docs.microsoft.com/en-us/dax/search-function-dax

https://docs.microsoft.com/en-us/dax/find-function-dax