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:

Columns | Data Types |
---|---|

Order ID | Single line of text |

Product Name | Single line of text |

Category | Single line of text |

Sub-Category | Single line of text |

Sales | Currency |

Profit | Currency |

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:

- Power BI SUM Measure
- Power BI COUNTIF Measure
- Power BI IF Statement Measure
- Power BI Top N DAX Function

Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book **Microsoft Power Platform A Deep Dive.**Â She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.