# 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:

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.

2. Under the Home tab, click on the New 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

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

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

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

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.

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

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.

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

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

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

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: