Solved: The condition of format rule 'Status' may be expen... - Page 2

Pointer · 05-28-2021 06:10 AM

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”

Suvrutt_Gurjar

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.

View solution in original post

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