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 colu...
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
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?