DAX Fridays! #95: Binning, Frequency and relative frequency | Data profiler

About this tutorial:

Video duration: 17:
This is the first of a series of videos about data profiling and descriptive statistics.
In today’s video, I will show you how to bin data, calculate the frequency and relative frequency using DAX.

What you think about the series? let me know in the comment box.

Download file here:


Get Northwind Dataset:


Incoming search terms:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

22 thoughts on “DAX Fridays! #95: Binning, Frequency and relative frequency | Data profiler

    Vince Slavov

    (October 9, 2018 - 8:49 am)

    Thank you for the nice video Ruth. This is really helpful for global profiling of the data in specific column, however on real report we slice the data per other attribute/s – for example if your report contains additional attribute "city" when slicing by this attribute the profile of the selected slice won't be the same as the global profile and the originally established bins won't be relevant anymore. The Microsoft Histogram custom visual automatically adjusts the bins displaying the profile of the selection dynamically, but this bins can't be used for other analysis. Do you know how we can achieve the dynamic bins effect (displayed in the histogram custom visual) with DAX ?

    Casey Davis

    (October 9, 2018 - 8:49 am)

    Ruth what a great video! Have you had any luck creating a cumulative relative frequency chart?

    Kiran B Chitari

    (October 9, 2018 - 8:49 am)

    Can u help me i am stuck in creating one report. PLease guide me.

    Hachi Adachi

    (October 9, 2018 - 8:49 am)

    I obviously slept through all of my statistics classes in college (and sorely regretting it after all these years), so this series would be SOOO incredibly useful and appreciated! Thanks, Ruth!

    Chris van Hasselt

    (October 9, 2018 - 8:49 am)

    Hey Ruth – I found this useful, but also a big question mark popped over my head. In the early part of the video, you note the calculation for the number of bins as Kbins = SQRT(Nitems – 1) -1 . You note there are others, and there are quite a few. Can you (or anyone else) provide a definitive reference for this formula? I've searched for this and a number of references refer to the floor of the square root of the number of items, but does your formula have a reference or name to back it up?

    Mehdi Hammadi

    (October 9, 2018 - 8:49 am)

    Very informative. I liked your comment denominator is like terminator :). Thank you for sharing Ruth

    Matej Mikuška

    (October 9, 2018 - 8:49 am)

    Hi Ruth, is it possible to do the binning also with measures? thx

    Adrian Iordache

    (October 9, 2018 - 8:49 am)

    cut() function from R is great for binning: http://www.jdatalab.com/data_science_and_data_mining/2017/01/30/data-binning-plot.html
    and now that Python is integrated (in the desktop as of Aug-18) can also use pandas's cut(): https://pandas.pydata.org/pandas-docs/stable/generated/pandas.cut.html#

    Jerry Kappa

    (October 9, 2018 - 8:49 am)

    Great Ruth… Any khi 2 test on the way ?


    (October 9, 2018 - 8:49 am)

    Great Ruth!
    I loved this Dax + statistics kind of video! Super!!

    Pratik Futane

    (October 9, 2018 - 8:49 am)

    Innovative… Looking after for next session on Average ??

    Tamir Basin

    (October 9, 2018 - 8:49 am)

    Ruth, you mentioned that you use the source:
    Wich file exactly did you use?

    Thank you,Tamir

    Andre Cavas Otero

    (October 9, 2018 - 8:49 am)

    I work with data like these all the time. I look forward to seeing the rest of the series. Thanks for sharing

    Gopa Kumar

    (October 9, 2018 - 8:49 am)

    Thank you Ruth for taking up the statistics side. Looking forward to your future videos in this area.

    Ankush Joshi

    (October 9, 2018 - 8:49 am)

    Really interesting video.

    Luke Zhang

    (October 9, 2018 - 8:49 am)

    where did you get the rainfall data? thank yoU!

    Norberto Vera Reatiga

    (October 9, 2018 - 8:49 am)

    Increible Ruth, como siempre vas al ritmo y hoy públicas esta excelente noticia!!! gracias!!! me tendrá atento!!!

    eladio gonzalez bardelli

    (October 9, 2018 - 8:49 am)

    Ruth una duda, tengo un amigo que esta haciendo un master y me consulto si es posible usando dax o power bi , hacer formulas para un Proceso Analítico de Red(ANP) , nose si se podrá o ya solo es posible usando algún software mas especifico en esas materias, que crees ? saludos

    Joel Rocha

    (October 9, 2018 - 8:49 am)

    Sempre quis fazer isso no DAX. Sensacional!


    (October 9, 2018 - 8:49 am)

    That was interesting. It's a good idea to explain DAX together with interpretation

    Sten B. Rasmussen

    (October 9, 2018 - 8:49 am)

    great way to go binning, usually i would use spss, but it's hard to use in a customer report without explanation, and a lot of cut and past.
    So it became a double power week

    Tamir Basin

    (October 9, 2018 - 8:49 am)

    Great video and most needed subject. Thank you :-), Tamir

Leave a Reply

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