• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / AVERAGEX

AVERAGEX

posted on September 14, 2017

« Back to Glossary Index

Syntax

AVERAGEX(<table>,<expression>)

Tutorial with example

In this video we will go through how to calculate averages using DAX. It might seem an easy task, but you will be surprised!

Download example file:

Link to demo file here.

Remarks

The AVERAGEX function enables you to evaluate expressions for each row of a table, and then take the resulting set of values and calculate its arithmetic mean. Therefore, the function takes a table as its first argument, and an expression as the second argument.

In all other respects, AVERAGEX follows the same rules as AVERAGE. You cannot include non-numeric or null cells. Both the table and expression arguments are required.

When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.

 

Was this helpful?
See Also:
  • AVERAGE
« Back to Index

Reader Interactions

Comments

  1. Antonio Rasco

    March 29, 2018 at 8:38 pm

    Jajaja, me di cuenta e intente cambiar el nombre pero no me dejaba! 🙂

    Reply
  2. Antonio Rasco

    March 28, 2018 at 9:08 pm

    Hola Raquel, tus videos y pagina son sencillamente fantasticos, me compre un libro de DAX y me costaba un poco seguirlo hasta que encontre tus videos. Muchas gracias por tu esfuerzo

    Reply
    • Ruth Pozuelo Martinez

      March 29, 2018 at 3:20 pm

      Hola Antonio!
      Muchas gracias, ya se lo diré a Raquel 😉
      Saludos,
      /Ruth

      Reply
  3. Rajan Mahal

    September 16, 2017 at 10:18 pm

    I really like this website. Very user friendly interface. Thank You!!

    Reply
    • Ruth Pozuelo Martinez

      September 24, 2017 at 2:37 pm

      Thanks!
      /Ruth

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In