Returns just those rows of a table that meet a condition. In CALCULATE it handles conditions too complex for a Boolean filter argument, though a Boolean filter is faster whenever one will work.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains FILTER in context, with comparison tables and the common traps.
Terms in this definition
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- CALCULATE
A DAX function that computes an expression after changing the filter context with filter modifiers, Boolean filters or table filters. Called with no filters, it still turns any row context into filter context, which is known as context transition.
Related terms
- AH
Short for Authentication Header, an IPsec protocol that verifies the sender and integrity of an entire IP packet but leaves it unencrypted. Network security group rules can filter on it, as they can on TCP, UDP, ICMP and ESP.
- ALLEXCEPT
Clears every context filter from a table except the ones placed on columns you list. In this DAX function, the first argument must be a base table and the rest must be columns belonging to it.
- AzureFrontDoor.Backend
Service tag for the IP addresses Front Door uses when contacting origins. Pairing it with a filter on the X-Azure-FDID header in an access restriction ensures only your own Front Door instance gets through.
- Blob index tags
Indexed, searchable key-value attributes set on blobs, which lifecycle rules can filter on via
blobIndexMatchand ABAC conditions can use; filtering by them isn't possible with a SAS. - Boolean filter expression
A true/false condition such as
'Product'[Color] = "Blue"passed as a filter to CALCULATE or CALCULATETABLE. Only one table's columns may appear in it, measures and nested CALCULATE calls are not allowed, and it overrides an existing filter on that column unless you wrap it in KEEPFILTERS. - Budgets
In Cost Management, spending limits you can scope and filter by tag, which raise alerts when actual or forecast spend nears or passes them.
- Button slicer
Lets report users filter by clicking styled tiles laid out in a grid; each tile can include a picture, conditional formatting and a highlight label.
- CALCULATETABLE
Works like CALCULATE but returns a table: a table expression is evaluated under a modified filter context, with filter arguments behaving exactly as they do for CALCULATE.