The condition of format rule 'Status' may be expensive and slow the user experience of your app warning

OR(
IN("Low Risk", SELECT(Records[Status], [GID]=[_THISROW].[GID])),
IN("Risk", SELECT(Records[Status], [GID]=[_THISROW].[GID])),
IN("High Risk", SELECT(Records[Status], [GID]=[_THISROW].[GID]))
)

With this formula, I color the parent table from the bottom table according to the situation, the formula works, but I get this warning, how can I use a simpler formula?

“The condition of format rule ‘Status’ may be expensive and slow the user experience of your app”

Could you update which is parent table? Any multirow expression format rule will be in general expensive. But probably better expression will be

ISNOTBLANK(INTERSECT(LIST(“Low Risk”, “Risk”, “High Risk”), [Related Records][Status]))

Assumes “Records” is the child table.

2 Likes

This is what I was looking for, thank you very much.

It was the first time I used it.

1 Like

Great.

One more point to note is the REF_ROWS column ( In this case [Related Records]) has always a list of keys of related child records. So one can easily build a list of related other fields’ values from the child table without having to create another SELECT() expression. ( [Related Records][Status] in this case)

2 Likes