Skip to content
Menu

Public Everscope rule

Iterator over a large table

ES-DAX-004version 1.0DAXhigh

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

  1. Measure the query plan and replace row iteration with a validated aggregation where equivalent.
  2. 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

  1. Version 1.0

    Initial published version.

Introduced on 2026-08-01