KEEPFILTERS

KEEPFILTERS modifies the way a CALCULATE filter interacts with the existing context: instead of replacing the filter on a column, it adds it by intersection. The result then respects both the filter already in place and the new one.

Example

CALCULATE([CA], KEEPFILTERS(Produits[Couleur] = "Rouge"))

Related concepts

The whole glossary