Get data with enum list as a conditon

[alhazen]

Hello Community,

I am trying to get data from the job column in the job_log table to the summary table.

I am using this formula, but it seems doesn't work at all. Is there anything wrong with my formula here?

SELECT(

 job_log[job],

   IN(

     [team],

       SELECT(

         summary[name],

           [name]=[_THISROW].[name]

        )

    )

)

Thank you so much for your help

[jyothis_m]

Please explain your filter condition for job_log[job] i.e. what you are trying to filter from the table.