"Compute_If" - for virtual columns

[Karimmc2]

Is there a way to achieve a "Compute if" for virtual columns? or any ideas on how to work around this?

Virtual columns can really drag down performance when working with complex expressions across large datasets. But I noticed that many times there is no need to compute the column for all the rows, it is just needed for a small fraction of them. In these cases it would be very handy to have a compute if option. 

Note: this is for cases in which security filters won't do the job because I still need the rest of the rows for some other calculation in the same app.

PD: as far as I know a FALSE statement in the Show_If won't prevent the expression from computing itself

[Marc_Dillon · Accepted solution]

Change your VC expression to IFS( condition , original-expression )