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
попробуй удалить ALL
L Count =
VAR _KewSearch= SELECTCOLUMNS( {"LS","LP"},"KeyWord",[Value])
VAR _Result = COUNTROWS(FILTER('MAIN_DATA TABLE','MAIN_DATA TABLE'[Code] in _KewSearch))
RETURN
_Resultpls 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 _ResultHi Ahmedx thank you but show same, it count all not on the specific Main No.
try
Hi Ahmedx thank you for the reply but the new calculated column we required is for the current table.
