Forum Discussion
How Count cells with specific Text in certain column
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
Anonymous , You can use
https://docs.microsoft.com/en-us/dax/containsstring-function-dax
calculate(count([Names]),CONTAINSSTRING([Names],"enhancement"))
or
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
4 Replies
Anonymous , You can use
https://docs.microsoft.com/en-us/dax/containsstring-function-dax
calculate(count([Names]),CONTAINSSTRING([Names],"enhancement"))
or
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
Thanks for the solution, But it count the header also?
