Calculate The MEDIAN Value In Power BI - Statistical Analysis wDAX

How To Calculate The MEDIAN Value In Power BI Using DAX

No comments

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.

Median 1

You will actually find that these techniques are very re-usable when completing other statistical analysis as well.

Median 2

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

 

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

 

 

***Learn more about Enterprise DNA Membership***membership banner 3

 

***** Related Links*****

Understanding How The AVERAGEX Function Works

Advanced Logic Within DAX Iterating Functions – Detailed Example

 

***** Related Course Modules*****

Mastering DAX Calculations

Solving Analytical Scenarios w/Power & DAX

Advanced DAX Combinations

 

***** Related Support Forum Posts*****

Median Of A Time Column

Calculating Median vs Alternate Percentile Ranks

Measure To Calculate Median Sale Price

For more support queries on MEDIAN click here…..

 

***Learn To Master Power BI Through Our Many Virtual Training Workshops***Enterprise DNA Events

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.