How to Average Measure in Power BI? [With Examples]

This Power BI tutorial will help you work with the Power BI Average measure.

I recently worked on a Power BI report, utilizing the average function to calculate the average of all sales values in a dataset.

In this tutorial, we will see the average measure in Power BI and a real-time example of how to average measure in Power BI. Also, I will tell you how to use average measures with filters in Power BI.

What is AVERAGE() Measure in Power BI?

The AVERAGE() measure in Power BI is a function used to calculate the average of a column or a set of values in a table. It takes a column or expression as its argument and returns the average numeric values within that column or expression.

The Power BI AVERAGE() function returns a decimal number representing the arithmetic mean of the numbers in the specified column.

Power BI AVERAGE function syntax:

AVERAGE(<column>)

Where:

Column = The column name that contains the numerical values.

How to Average Measure in Power BI

This example shows how to create an AVERAGE() measure in Power BI.

Here, we have a SharePoint list (Orders) that contains below columns with various data types:

ColumnsData Types
Order IDSingle line of text
Product NameSingle line of text
CategorySingle line of text
Sub-CategorySingle line of text
SalesCurrency
ProfitCurrency
power bi average of a measure

Let’s create a measure in Power BI to explore how the average measure functions.

1. Open Power BI Desktop and load the data. Then, you see data in the Data pane.

Average of a measure power bi

2. Under the Home tab, click on the New measure.

power bi calculate average of a measure

3. In the formula bar, click the below expression. Then click Commit.

Average Sales = AVERAGE(Orders[Sales])

Where:

  • Average Sales = Name of the measure
  • Orders = Name of the Table
  • Sales = Name of the Column
power bi average measure

4. Under the Home tab, expand Visual gallery(black box) -> Click the Card visual.

calculate average of a measure power bi

5. Then, using the +Add data option, add Average Sales(Measure)  into the Field in the Card visual.

power bi dax average of a measure

6. The Card visual shows the Average Sales in the Order Table.

how to average a measure in power bi

I hope you follow the above steps. This way, you can use the average function in Power BI.

Average Measure with Filter in Power BI

In this example, I will show you how to use average measures with filters in Power BI.

1. Under the Home tab, expand Visual gallery(black box) -> Click the Table visual.

power bi get average of a measure

2. Then, using the +Add data option, add Category, Sales, and Average Sales into the Columns field.

Average of measures with filters in Power Bi

Here, I want to calculate the average of furniture. Follow the steps below to do this:

1. Under the Home tab, click on the New measure.

power bi calculate average of a measure

2. In the formula bar, click the below expression. Then click Commit.

Furniture Average Sales =
CALCULATE(
		AVERAGE('Orders'[Sales]),
		FILTER(
			'Orders',
			'Orders'[Category] = "Furniture"
		)
	)

Where:

  • Furniture Average Sales = Name of the Measure
  • CALCULATE = DAX Function
  • Orders = Name of the Table
  • Sales = Name of the Column
  • Category = Name of the Column
  • FILTER = DAX Function
how to calculate average of a measure in power bi

3. Next, use the +Add data option to include ‘Furniture Average Sales‘ in the same table we created above.

calculate average of measure in power bi

4. Now, you’ll observe only the average sales for the furniture category in the ‘Furniture Average Sales‘ column.

Average Measure with Filter in Power BI

This way, you can use average measures with a filter in Power BI.

Conclusion

The average () function in Power BI is used to average values in a table.

Now, you know about the Power BI AVERAGE() measure. This tutorial taught us what the Power BI AVERAGE () measures and how to use the AVERAGE () in the Power BI measure. Additionally, we explained how to use average measures with filters in Power BI.

Moreover, you may like some more Power BI articles: