From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Unlock this course with a free trial

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

Identify implicit measures and replace with explicit measures

Identify implicit measures and replace with explicit measures - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Start my 1-month free trial Buy for my team

Identify implicit measures and replace with explicit measures

“

- [Instructor] Okay, so in this sub lesson we are going to identify implicit measures and replace them with explicit measures. So implicit DAX is written for numeric columns that have aggregate functions applied to them. A default summarization can be applied to columns, implicit measures can handle only basic calculations. They can be overridden at the visualization level and using measures allows the model to control the data type, formatting, and calculations. So let's go to the (indistinct) desktop and take a look. Okay, so I am on the (indistinct) desktop and if we recall earlier on, we created a calculator column called line total sales, which was the internet sales unit price multiplied by the order quantity. When we built that calculator column out, it automatically had a default summarization applied to it, so sum is the default default for setting up default summarizations. And we could go ahead and override this with a sum average min max count or distinct count. Or we…

Contents