Create a Dynamic BI Distribution Chart in PowerPivot using DAX

A few weeks ago I published a post detailing the process by which to create a histogram with dynamic bins using DAX in PowerPivot. While standard histograms are useful to visualize distribution, even greater analytic value can be derived from that same data by converting a histogram into a distribution chart. Those of you who have taken courses in statistics are probably familiar with the normal distribution curve, which is a distribution chart that expresses common variation from the mean.