//First, get the list of pic_name values from PIC_Pekerjaan where id_pekerjaan matches VarGalPaketPekerjaan.ID
Set(NewVar, Filter(PIC_Pekerjaans,ID_Pekerjaan.ID=VarGalPaketPekerjaan.ID).PIC_Name);
//Now, filter the Akuns data source to only include records where id is in varPICNames
Set(varFilteredAkuns,
AddColumns(
Akuns,
FilteredPIC,
Filter(NewVar, Akuns[@IDAkun]=PIC_Name.IDAkun)));
what the first code does is get the list of pic_name values from PIC_Pekerjaan where id_pekerjaan matches VarGalPaketPekerjaan.ID the 2nd code is what got me confused, I want to get items from the Akuns table based on the first variable that i made, but what the 2nd code does is just get the whole akuns table without filtering anything. Any help would be appreciated
