From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

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

Comprehensive create calculated columns and measures: Part two

Comprehensive create calculated columns and measures: Part two - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Comprehensive create calculated columns and measures: Part two

“

- [Chris] All right, so let's pick up on where we left off, so this part two is now where we're going to start taking a look at measures to solve the problem which we have. So what I'm going to do now is I'm going to go back to my sales table. I'm going to right click and say new measure. What I want to do this time is I'm going to go ahead and make it a little bigger, and drop in a measure calculation looks like this. I want to take my total margin, create that as a measure, and what it's going to do is sum up the line margin which we created back in the previous sub lesson. So I go ahead and enter, we get that created. I'm actually just going to go make sure I format it properly first. I'm going to say English United States, and now that I've done that, I'm going to take this and drag it on the canvas. So when I do that, I take a look at my total margin, and probably not to any surprise of you that that is the same as the sum line margin here that is using the default aggregation or…

Contents