FILTER, VALUES and DAX queries

FILTER, VALUES and ALL are functions that return a table. FILTER keeps the rows satisfying a condition, VALUES the distinct values of a column in the current context. DAX queries start with EVALUATE and let you test these tables, for example in DAX Query View.

Example

EVALUATE FILTER(Produits, Produits[Prix] > 100)

Related concepts

The whole glossary