Skip to content
Menu

Public Everscope rule

FILTER over an entire table

ES-DAX-002version 1.0DAXmedium

A DAX expression filters a complete table instead of a narrower column predicate.

What this rule checks

A DAX expression filters a complete table instead of a narrower column predicate.

Everscope evaluates only the metadata needed for this deterministic check. It does not read dataset rows or values.

Why this is a risk

Whole-table iteration can add avoidable Formula Engine work and slow interactive queries.

In a governed environment this can weaken traceability, operational reliability, or the evidence available to reviewers and auditors.

How to resolve it

  1. Use Boolean column filters in CALCULATE where equivalent, or filter only required columns.
  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