 # How To Calculate The MEDIAN Value In Power BI Using DAX

In this tutorial, I want to show you how we can calculate the median value from a list of values that we have inside of Power BI.

With a lot of the statistical functions that we can use in DAX, there is a need to understand how they calculate and how they operate over tables of values.

In this particular example, we’re going to dive into the MEDIANX function.

As a reminder of what the MEDIAN value actually is:

The median is the value separating the higher half from the lower half of a data sample (a population or a probability distribution). For a data set, it may be thought of as the “middle” value.

I’m going to show you how you can place a virtual table inside of this function and then evaluate through that virtual table to obtain the ultimate result; the median result.

We create the virtual table here using the SUMMARIZE function in DAX. You will actually find that these techniques are very re-usable when completing other statistical analysis as well. This is a really good review of iterating functions also and how they work inside of Power BI.

You need to master these concepts if you are to utilize Power BI and DAX to the fullest.

Enjoy working through this tutorial. If you do want some further study around this type of DAX functionality inside of Power BI, certainly check out Enterprise DNA Online for much more content.

Specifically this particular course module below.

DAX Formula Deep Dives

Some related tutorials around iterating functions for your review.

Key Concepts For Iterating Functions In Power BI

Iterating Functions – SUMX & AVERAGEX, Why You Need To Understand These Well

How To Understand Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

Plenty to learn during this video tutorial.

Sam

***** Related Course Modules*****
Mastering DAX Calculations
Solving Analytical Scenarios w/Power & DAX