Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
10 months ago
Solved

Containsstring and Count

Hi good day  Can anyone help me on my calculated column, i have two table that connected. I want to count the number of Job.   DESIRED OUTPUT   Table Connection    JC Count ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    10 months ago

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ahmedx's avatar
Ahmedx
Super User
10 months ago

попробуй удалить ALL

L Count = 
VAR _KewSearch= SELECTCOLUMNS( {"LS","LP"},"KeyWord",[Value])
 VAR _Result = COUNTROWS(FILTER('MAIN_DATA TABLE','MAIN_DATA TABLE'[Code] in _KewSearch))
RETURN
_Result