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 =
CALCULATE(
COUNTROWS(MAIN_DATA),
FILTER(
'MAIN_DATA',
(CONTAINSSTRING('MAIN_DATA'[Job No.], "LP") || CONTAINSSTRING('MAIN_DATA'[Job No.], "LS") || CONTAINSSTRING('MAIN_DATA'[Job No.], "LI") || CONTAINSSTRING('MAIN_DATA'[Job No.], "LM"))
&&
NOT CONTAINSSTRING('MAIN_DATA'[Job No.], "QF")
&&
NOT CONTAINSSTRING('MAIN_DATA'[TQ], "SQ")
)
)
Thank you
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
17 Replies
- Ahmedx
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 thank you but show same, it count all not on the specific Main No.
- Ahmedx
try
- Ahmedx
pls try
- AllanBerces
Hi Ahmedx thank you for the reply but it count the overall instead of per Main No. Please note my MAIN DATA TABLE, Main No column has many different no.
DESIRED OUTPUT
Thank you