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 single aggregation measures

Create single aggregation measures - 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 single aggregation measures

“

- Okay, so in this sub-lesson, we are going to create single aggregation measures. So first off, what are measures? Measures are an aggregate of a column. They do not take up space in the data model, so we initially go and create a measure. You're essentially just saving the definition for that calculation. Their value is calculate runtime, which means as you go to use 'em on a report, that's when their value is calculated. So that gives measures incredible amount of flexibility, but it can, in certain situations, cause performance issues at report time and we'll talk during this course about different ways that you can go ahead and monitor that and prevent those situations. Typically, they reside in fact tables. So when you go and create them, we usually create them inside of a fact table and at the end of the day they belong to the data model itself. So even though we're creating 'em in the fact table, that's where we're logically organizing them, they technically belong to the data…

Contents