Public Everscope rule
Iterator over a large table
A DAX iterator evaluates row by row over a large table.
What this rule checks
A DAX iterator evaluates row by row over a large table.
Everscope evaluates only the metadata needed for this deterministic check. It does not read dataset rows or values.
Why this is a risk
Large iterator workloads can create high Formula Engine cost and slow report interactions.
In a governed environment this can weaken traceability, operational reliability, or the evidence available to reviewers and auditors.
How to resolve it
- Measure the query plan and replace row iteration with a validated aggregation where equivalent.
- Validate the change with the accountable owner, rerun the same metadata scan, and retain the before-and-after evidence.
Affected object types
- measure
Rule history
- Version 1.0
Initial published version.