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.
Some related tutorials around iterating functions for your review.
Plenty to learn during this video tutorial.
Insert your email address and press Download for access to the files used in this article.
***** 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
Enterprise DNA Events