Defined on one visual instead of within the model, so only fields shown by that visual are usable. Good for running totals, moving averages or percentages of a total.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Visual calculation in context, with comparison tables and the common traps.
Related terms
- Custom totals
Lets a table or matrix column total show something other than the default, such as an average, minimum, maximum, count, distinct count or no total, based on the rows shown; you pick Customize total calculation. Power BI builds this with a visual calculation and appends _Base to the source column's name.
- HIGHESTPARENT
Pass this to the Reset argument of a visual calculation function and the calculation starts again at the top level of the visual's hierarchy, counted in absolute mode. Using the number 1 has an identical effect.
- LOOKUP
Inside a visual calculation, this DAX function retrieves a value from the visual matrix using whatever filters you supply, and works out any you omit from the context it is evaluated in.
- LOOKUPWITHTOTALS
Inside a visual calculation, this DAX function retrieves a value from the visual matrix using whatever filters you supply; for any missing ones it uses the total.
- LOWESTPARENT
Pass this to the Reset argument of a visual calculation function and the calculation starts again at the parent immediately above the current level, counted in relative mode. Using the number -1 has an identical effect.