Название: Microsoft Power BI Visual Calculations: Simplifying DAX
Автор: Jeroen ter Heerdt, Madzy Stikkelorum, Marc Lelijveld
Издательство: Microsoft Press/Pearson Education
Год: 2026
Страниц: 353
Язык: английский
Формат: epub
Размер: 59.6 MB

Seasoned experts Jeroen ter Heerdt, Madzy Stikkelorum, and Marc Lelijveld help you master visual calculations in Power BI for transformative data insights Microsoft Power BI Visual Calculations: Simplifying DAX is a comprehensive guide that demystifies the innovative feature of visual calculations in Power BI. Jeroen, a Principal Product Manager at Microsoft, Madzy, a Data Analytics Consultant, and Marc, a Microsoft Data Platform MVP, bring their extensive expertise to this book, offering you a practical approach to mastering visual calculations. The book is designed to simplify DAX, making it accessible to beginners and empowering you to transform raw data into actionable insights. You will learn to implement visual calculations, understand their benefits, and apply them effectively in real-world scenarios, ultimately enhancing your ability to make data-driven decisions.

DAX is a critical piece of Power BI. It allows authors to build reusable semantic models to power exploration, reporting, and AI. DAX measures express business logic as dynamic, reusable calculations that work across a variety of dimensions and scenarios. However, DAX has a steep learning curve for new users. Some of the concepts that make DAX so powerful—like filter context and the many features of semantic models—also make DAX challenging to learn. It demands clear thinking about row and filter context, which is hard for beginners, because it asks them to ignore the visual in front of them and reason in the abstract space of the semantic model.

Many common reporting and visualization tasks shouldn’t require a complete understanding of these concepts. Tasks like showing the difference between two metrics or adding a running sum to a chart are easier to do using the data in a visualization. These ideas led us to add visual calculations to Power BI. Instead of pushing every calculation into measures that operate independently over base tables, you can work with the result set the visual already produced. That shift narrows the gap between how analysts think and how the engine executes.

Visual calculations are expressions defined as part of a visualization, and they work over the data in that visualization. This lets you write a calculation using specific numbers you can see rather than imagining how filter context might create those numbers from the semantic model. Visual calculations provide functions that already understand the structure of the visual to let you easily write running sums or moving averages. These are just two of the ways visual calculations make it easier to build powerful visualizations in Power BI.

There was a long path to visual calculations. Years before the team debated the investment, Amir Netz asked Jeffrey Wang to look at a performance escalation in a customer DirectQuery model. A measure was generating slow SQL. The customer was confused, and they were right to be. The visual already showed a small set of values from another measure—values that contained everything needed for the more complex result. Yet what looked simple on the canvas triggered a cascade of large, slow, and convoluted SQL. The gap between what is visibly simple and what the engine had to compute was a persistent source of friction. Incidents like this pushed us toward an approach that simplifies the mental model and speeds evaluation by operating at the level of the visual when it makes sense. It still took years and foundational work, including DAX window functions, before visual calculations officially took off.

By reading this book, you will:

Understand the fundamentals of visual calculations in Power BI
Create your first visual calculation with step-by-step guidance
Explore advanced concepts like resetting context in visual calculations
Compare visual calculations with other Power BI calculation options
Master the performance characteristics of visual calculations
Utilize specific functions designed for visual calculations
Implement practical use cases like running sums and moving averages
Enhance visual calculations with regular DAX expressions
Optimize operational processes using data-driven insights
Unlock the full potential of Power BI for strategic decision-making

About This Book:

For Power BI users who want to simplify DAX and unlock the full potential of visual calculations without the usual complexities
For business executives, managers, and data enthusiasts looking to transform raw data into actionable insights for strategic decision-making

Both newcomers and seasoned DAX users benefit from this approach. Newcomers can reason from what is on the screen and learn many DAX features without starting in the deep end. Experts can reduce model clutter by moving visual-specific calculations, such as formatting, into the visual and achieve more predictable cost in DirectQuery and composite models. Microsoft Power BI Visual Calculations: Simplifying DAX explains how visual calculations work, where they shine, how to keep performance stable as visuals grow more complex, and when classic measures remain the right tool. Visual calculations are still DAX expressions, and the power of DAX is still available when you need it. DAX measures are still a critical tool for building reusable semantic models that are the foundation of exploration, reporting, and AI in Power BI. However, visual calculations give you a way to more easily accomplish many common reporting and visualization tasks.






ОТСУТСТВУЕТ ССЫЛКА/ НЕ РАБОЧАЯ ССЫЛКА ЕСТЬ РЕШЕНИЕ, ПИШЕМ СЮДА!