From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,000 courses taught by industry experts.

Use the ALL function

Use the ALL function - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Use the ALL function

“

- [Instructor] All right, so in this sub lesson we're going to take advantage of a function called the ALL function. And what it is going to do is allow us to override the filter context for that particular expression. And where these are really useful is when you're creating ratio calculations. Because as you can imagine, if you had no way of overriding the filter context, your numerator and denominator would always be the same because they would always be equally affected by the filter context. Okay, so let's look at an application of this function. So what I'm going to do is go to my Sales table, right click, say new measure. Go ahead into the formula bar here, drop my line of code. And here I've got this new measure called Count of ALL Sales Orders. I just use this in here just because I want to distinguish the fact that this is counting all of them. And what is happening here is we take a look at the Sales table right here, and it's being wrapped in this ALL function. So it says,…

Contents