From the course: Using Power BI with Excel

Unlock this course with a free trial

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

Implicit vs. explicit measures

Implicit vs. explicit measures - Power BI Tutorial

From the course: Using Power BI with Excel

Start my 1-month free trial Buy for my team

Implicit vs. explicit measures

“

- [Instructor] There are two different types of measures in Power BI; explicit and implicit. Now, explicit measures require a basic understanding of DAX. In order for you to create an explicit measure, you need to create a DAX calculation that explicitly states what kind of aggregation a measure is going to use. Now, with implicit measures, it's much easier to change your aggregation. I've gone ahead and built out a very basic data visualization in the Reports View of Power BI. This will help us give us some context when working with implicit measures. The way that you change implicit measures is you come over to the Values box and select this dropdown menu. So this bar chart looks at Service Type by Sales. And if we hit this dropdown menu on Sales, we can now see the different aggregations for this measure. Power BI will automatically choose Sum, but for instance, say we want to see Average Sale by Service Type. All we…

Contents