Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyContainsstring 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 ...
Sorry, I optimized the code.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ahmedx
Super User
Super Userпопробуй удалить 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
AllanBercesPost Prodigy
Post ProdigyHi Ahmedx thank you but show same, it count all not on the specific Main No.
- Ahmedx
try
- AllanBerces
Hi Ahmedx thank you for the reply but the new calculated column we required is for the current table.
- Ahmedx
Post the file, I don't know what you have there.(current)