Power BI & Data Analytics · IACT Training Blog
Visual calculations are one of the most significant DAX changes in years, and with the May 2026 Power BI update they reached general availability. They let you define a calculation directly on a visual, using the rows and columns already in that visual, which makes running totals, period-over-period comparisons and moving averages dramatically easier to write and maintain.
What a visual calculation actually is
Traditional measures evaluate against the whole data model and have to reconstruct context with functions like CALCULATE and ALLSELECTED. A visual calculation, by contrast, runs on the visual matrix after the query returns, so it can simply refer to the values it can already see. That removes a whole layer of context juggling.
To add one, select a visual, open the new visual calculations edit mode, and write an expression such as Running total = RUNNINGSUM([Sales]). The result becomes a new field on that visual only. Microsoft ships helper functions including RUNNINGSUM, MOVINGAVERAGE, PREVIOUS, NEXT, FIRST, LAST and COLLAPSE that act as friendly shortcuts to the underlying DAX window functions.
Where they shine
- Running totals and cumulative figures across the rows of a table or matrix.
- Period-over-period change and percentage growth without separate measures.
- Moving averages to smooth noisy trend lines.
- Ranking and percent-of-total calculations scoped to exactly what the visual shows.
Because the logic lives on the visual, you avoid cluttering the model with single-use measures, the DAX is shorter, and the calculation respects the visual’s own sorting and grouping automatically.
When to stick with measures
Visual calculations are not a replacement for the model. If a calculation needs to be reused across many reports, drive other measures, or feed row-level security, build a proper measure. Visual calculations cannot be referenced outside their visual and they recompute on the visual result set, so for very large or widely shared logic, a well-written measure is still the right tool.
The practical rule we teach at IACT: reach for a visual calculation when the maths is about the shape of this particular visual (a running total down these rows), and reach for a measure when the maths is about the business (total revenue, anywhere it appears).
Getting started safely
Visual calculations are now generally available, but treat them as a complement to solid data modelling rather than a shortcut around it. A clean star schema and correct relationships still determine whether your report is fast and trustworthy. Layer visual calculations on top of that foundation, not instead of it.
Train with IACT
IACT’s Power BI courses take you from data modelling and DAX to interactive dashboards. Learn visual calculations, measures and the star schema thinking that makes reports fast.