Forum Discussion
Solved
Using count with search text in column.
Hello everyone, I would like helping for counting a specific amount of services in a table. i will list the sample. SERVICE CODE OBS
2652016000002 102023 XXXXXXXXXXXXXXXXXXX Alt.TL: de A ...
You could do it like this:
Custom Column:
ContainsText = SEARCH("Alt.TL: de A p/ B",[OBS],1,0)Measure:
MyCount = CALCULATE(COUNTROWS(Codes),FILTER(Codes,Codes[CODE]=102023 && Codes[ContainsText]<>0))
You could do it like this:
Custom Column:
ContainsText = SEARCH("Alt.TL: de A p/ B",[OBS],1,0)Measure:
MyCount = CALCULATE(COUNTROWS(Codes),FILTER(Codes,Codes[CODE]=102023 && Codes[ContainsText]<>0))
Thks smoupre,
My main table had 1 blank space more than it should, after that everything worked fine.
Awesome! Glad you got it working!