A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ALL in context, with comparison tables and the common traps.
Terms in this definition
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- 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.
- REMOVEFILTERS
A DAX filter modifier, used within CALCULATE, that clears any filters on given tables or columns. When clearing filters is all you want, it is recommended over ALL.
- intent
A rule in VCF Operations for networks stating how the network ought to behave (say, MTU consistency, reachability or segmentation), regularly tested against a model of everything the network could do. Custom or system-supplied.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.
Related terms
- Abstraction levels
Four layers that make an architecture easier to talk about: Contextual answers why, Conceptual what, Logical how and Physical with what. Every level spans all four architecture domains.
- Access keys
Pair of 512-bit keys belonging to a storage account; every account SAS and service SAS is signed with one of them. Once both are regenerated, direct key access and all those SAS tokens stop working.
- Accuracy (classification metric)
Overall measure for a classification model: the share of all test cases it predicts correctly.
- ACR Tasks
Capability present in all Azure Container Registry SKUs for building, pushing and patching images in the cloud, through quick tasks (
az acr build), triggered tasks or multi-step tasks. - Active Directory Recycle Bin
Once switched on it can't be disabled, and it needs Windows Server 2008 R2 forest functional level or higher. Removed objects retain all attributes, so restoring them doesn't call for an authoritative restore.
- Additional local administrators
Microsoft Entra ID P1 device setting that grants selected users local administrator rights across all Microsoft Entra joined devices. Targeting only some devices is not possible.
- Agent identity blueprint
Template in Microsoft Entra Agent ID that holds credentials for one type of agent and obtains tokens for the agent identities created from it. Policies like Conditional Access set on it reach all those identities; Azure RBAC roles cannot be assigned to it.
- Agent Registry
A central list, reached in the Microsoft 365 admin center via Agents > All agents > Registry, of all agents people in your organisation can use. It flags overall numbers, ownerless agents and those that aren't managed.