Forum Discussion
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 ...
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
pls try
Q Count =
VAR _KewSearch= SELECTCOLUMNS( {"QP","QF","QK","QL"},"KeyWord",[Value])
VAR _Cod = MAX('MAIN_DATA TABLE'[Main No])
VAR _Result = COUNTROWS(FILTER(ALL('MAIN_DATA TABLE'),'MAIN_DATA TABLE'[Code] in _KewSearch&&'MAIN_DATA TABLE'[Main No]=_Cod))
RETURN
_Result
-----------------
L Count =
VAR _KewSearch= SELECTCOLUMNS( {"LS","LP"},"KeyWord",[Value])
VAR _Cod = MAX('MAIN_DATA TABLE'[Main No])
VAR _Result = COUNTROWS(FILTER(ALL('MAIN_DATA TABLE'),'MAIN_DATA TABLE'[Code] in _KewSearch&&'MAIN_DATA TABLE'[Main No]=_Cod))
RETURN
_Result
Hi Ahmedx can i use this as calculated column