How do I calculate the average in Power BI, and can you provide an example?

By /

Power BI is a business intelligence tool that allows users to visualize and analyze their data. To calculate the average in Power BI, you can use the “Average” function in the “Measure” tab. This function takes a column or expression as input and calculates the average of the values. For example, if you have a dataset with sales data for different products, you can use the “Average” function to calculate the average sales for all products. This will give you a single value that represents the average sales for your entire dataset.

Calculate Average in Power BI (With Example)

You can use the following syntax in DAX to calculate the average value in a column:

Avg Points = AVERAGE('my_data'[Points])

This particular example creates a new measure named Avg Points that calculates the average value in the Points column of the table named my_data.

The following example shows how to calculate the average value of a column in Power BI in practice.

Example: How to Calculate Average in Power BI

Suppose we have the following table in Power BI named my_data that contains information about points scored by basketball players on various teams:

Suppose we would like to calculate the average value in the Points column.

To do so, click the Table tools tab along the top ribbon, then click the New measure icon:

Then type in the following formula into the formula bar:

Avg Points = AVERAGE('my_data'[Points])

This will create a new measure named Avg Points that contains the average of values in the Points column of the table:

Power BI calculate average

If we’d like, we can display this value by going to the Report View in Power BI, then by clicking the Card icon under the Visualizations tab, then by dragging the Avg Points measure under the Fields label:

This will produce the following card that displays the average value in the Points column of the table:

We can see that the average value in the Points column is 19.91.

If we click on any of the individual names in the Team column of the table in the report, then the card will automatically update to show the average points value for that particular team.

For example, suppose we click the Mavs team name in the table:

The card automatically updates to show that the average of values in the Points column for the Mavs is 18.75.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

x

Related terms:

  1. How can I perform fuzzy matching in Power BI? Can you provide an example of fuzzy matching in Power BI?
  2. How can I calculate the sum in Power BI, and can you provide an example?
  3. How can I calculate the maximum value in Power BI, and can you provide an example?
  4. How can I use the “NOT IN” operator in Power BI, and can you provide an example?
  5. How do you perform an Inner Join in Power BI, and can you provide an example?
  6. How do you perform an Anti Join in Power BI and can you provide an example?
  7. How can I change the legend order in Power BI, and can you provide an example?
  8. What is the process for obtaining the first day of the week in Power BI and can you provide some examples?
  9. What is the process to find the maximum date in Power BI, and can you provide an example?
  10. What is the procedure for calculating standard deviation in Power BI, and can you provide an example?