DAX Visual Calculations: What You Need to Know
summary
Demo uses the AdventureWorks sample and the Power BI/Fabric preview visual calculations feature (enable via Options > Preview features, released Feb 2024). Visual calculations run row/column-aware functions like running sum, moving average, first/last and a window/range low‑level API, and introduce rows columns axis navigation and collapse/expand to change granularity. The engine yields surprisingly many distinct level combinations (about 55), totals compute at separate levels, running sums work without complex CALCULATE/filter gymnastics, and limits include scope tied to the visual and no access to slicers or model objects.
AI-written summary · about
chapters (22)
- 0:00DAX Visual Calculations intro
- 1:17Enabling the feature
- 3:04Templates for visual calc
- 4:54First, Last functions
- 7:00Sort order and hiding steps
- 9:34Visual vs regular DAX
- 11:53Visual context navigation
- 14:25AIS rows and columns
- 16:11Demo: Axis reference
- 18:43Totals behavior
- 21:31Visual context hierarchy
- 22:34Levels and combinations
- 27:17Counting rows/columns
- 31:18Filter context in visuals
- 34:08Hierarchy collapse/expand
- 36:00Demo: Collapse/expand
- 39:17Sorting with totals
- 42:31New functions overview
- 44:26Demo: Window function
- 47:38Syntax sugars
- 48:41Red flags and best practices
- 49:46Q&A
related talks
19mDAX in 20 Minutes - The Hard Parts
54mData Visualization with Power View and the Tabular Model
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
01h 05mDynamic Presentation Using Excel CUBE Formulas
30mEmpower every BI professional to do more with Fabric
51mTroubleshooting Power BI Report Performance
21mSupercharge Power BI Tooltips
51mPower BI Composite and Hybrid Models