VALUES

In the Ultra Transcenders books

PL-300

Each book explains VALUES 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.

• BLANK

  DAX uses BLANK to mean no value at all. It resembles NULL in SQL but behaves more like an empty cell in Excel, so adding 20 to it returns 20; the BLANK function creates one and ISBLANK detects it.

• 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.

• FILTER

  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.

Related terms

• 5-tuple

  The five values that identify a flow: protocol plus the source and destination IP addresses and ports. Azure Load Balancer hashes them by default to spread traffic, and IP flow verify in Network Watcher takes them as its input.

• AI splits

  A decomposition tree mode, shown by a light-bulb icon, in which Power BI itself picks the field to expand next, looking for high or low values in absolute or relative terms. It is unavailable in Power BI Report Server, Azure Analysis Services and publish-to-web reports.

• Anomaly detection

  Identifying data points or time-series values that look out of the ordinary, such as fraud or a spike from a sensor. Microsoft retired the dedicated Azure AI Anomaly Detector service on 1 October 2026.

• App settings

  Environment variables injected into an App Service app as name/value pairs, taking precedence over values in appsettings.json or Web.config. Each can be marked as specific to a slot.

• Application Gateway autoscaling

  Capability of Application Gateway v2 that varies the instance count between configured minimum and maximum values, at most 125. Plan subnet size for that maximum, adding one address per private frontend IP.

• AUMID

  The unique ID Windows assigns to each installed app. Kiosk (Assigned Access) configurations use it to list permitted apps, and you can find the values with Get-StartApps.

• AUTO CDC

  The Lakeflow pipelines API for change data capture: it merges incoming changes into a streaming table, keeping either just the latest values (SCD 1) or full history (SCD 2), and uses an ordering column to cope with records that arrive late. A Python-only snapshot variant also exists.

• Autotune

  A preview option in Fabric Spark that studies previous runs to pick better values for shuffle partitions, broadcast join threshold and max partition bytes query by query. It's disabled by default (spark.ms.autotune.enabled), limited to Runtime 1.2, and incompatible with private endpoints and high concurrency mode.