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- Ahmedx
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
AllanBercesHi Ahmedx thank you for the reply but it shows blank
- AllanBerces
Hi Ahmedx can i use this as calculated column
- AllanBerces
- AllanBerces
Hi 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.