Does mixing delegable functions and non-delegatable functions work? I figured I could filter down the results for delegatable functions to around less than 500, then use that as a source for a non-delegable function and filter it even further, kind of this this
Filter(Filter(Task, mainexecid=executiveid), Task_x0020_Status='Tasks View Type'.Value, Executive.Id=MainExec.ID)
The inside filter is delegatable since it just compares 2 text fields (mainexecid and executiveid), however, the outside filter takes it as a source and compares lookup values, which makes it delegatable.
My question is less about effeciency because I have specific requirements for doing this, but more so questioning if this works... or does everything automatically become non-delegatable?
