From the course: Microsoft Project for the Web: Reporting with Power BI

Unlock the full course today

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

Working with measures

Working with measures

From the course: Microsoft Project for the Web: Reporting with Power BI

Start my 1-month free trial Buy for my team

Working with measures

“

- [Instructor] Sometimes you need to just have a quick total of the number of projects as an example, but you don't want to necessarily put that into your data set. So to do that, you can go to the Home ribbon and select Quick Measure, and select the dropdown here, and we'll use a running total to count the number of projects that we have in here by name. So we'll click the Projects drop down and select project name and move it up to the base field. We'll also make sure that we're counting distinct projects should we have a duplicate name, so we'll select Count Distinct, and we'll put the project name in the field. We'll use the ascending sort, even though this is a text project count of names, we'll leave it as ascending. If we had text values, you would get them in alphabetical order. We'll press OK to see that count show up. And what Power BI has done is created a DAX statement to reflect what we've just asked it…

Contents