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.

Implicit vs. explicit measures

Implicit vs. explicit measures - 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

Implicit vs. explicit measures

“

- [Instructor] Measures fall within two categories: implicit or explicit. Implicit measures are automatically created when adding numerical fields to visuals. You can identify numeric fields by the sigma icon under the Data pane in the Power BI Desktop report view. Note, the sigma icon means it's implementing some type of aggregation. The default in Power BI is sum. To see the aggregation, select the numerical field and look under the Column tools contextual menu in the Properties section, and you'll see the type of summarization. The default is sum. To see the other options for summarization, click the dropdown menu. You'll also have the option not to summarize. If that option is selected, then the sigma icon will disappear from beside the field. Explicit measures use DAX formulas to summarize model data. Explicit measures are measures where rewrite the DAX formula. In that way, we can explicitly perform the…

Contents