From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Demo: Creating a full measure

Demo: Creating a full measure - Power BI Tutorial

From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Start my 1-month free trial Buy for my team

Demo: Creating a full measure

“

- [Instructor] The difference between a quick and a full measure is that for quick measures, there are predefined calculations, and we can simply choose the fields to involve in these calculations. For full measures, we construct formulas ourselves based on the type of questions we want to ask of our data. To create a full measure, you can right-click on a table from the report view and select new measure, or select new measure under the modeling tab. So I'm going to select our sales table and I can simply select new measure. In the previous video, we looked at how to calculate our profit margin using our quick measure. Now we can simply reconstruct the same measure in this video using a full measure. So let's start with our name. So on the left of the equal sign is where you name the measure. So let's call this one Profit % because there's a profit margin in our model already and we can't have two measures with the…

Contents