From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create visual calculations by using DAX

Create visual calculations by using DAX - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Create visual calculations by using DAX

“

- [Instructor] In this sub-lesson, we are going to create visual calculations by using DAX. So let's introduce visual calculations. Visual calculations in Power BI are data analytics expressions or DAX calculations defined on a visual. Unlike measures, they aren't stored in the model, but on the visual you're working with, they make it easier to create calculations that were previously hard to create, leading to simpler decks, easier maintenance, and better performance. When creating a visual calculation, you don't have to worry about the complexity of the semantic model or filter context, you just work with what's on the visual, making it easier to understand and check your work. They can refer to any data in the visual, including columns, measures, or other visual calculations. Many of the functions have an optional axis parameter, which can only be used in visual calculations. It influences how the visual calculation traverses the visual matrix. By default, it is set to the first…

Contents