Forum Discussion

Gezz's avatar
Gezz
Regular Visitor
4 years ago

Bell Curve using Dax

Hi,   I have a table TTF Raw Data + Formulas Added - with a column called Average Days - I have created a measure for Mean, Median, Standard Deviation and X-3σ and X+3σ - figures below.    Mean =...
Gezz's avatar
Gezz
Regular Visitor
4 years ago

Hi Inbendlin

 

Thanks for your help.

 

I created a table using GENERATESERIES and a Calculated Column. 


I have a Table with one column from with numbers -5 through to 120 and the another with the distribution values for these figures. The -5 through to 120 are the range in which all of the average days values fall within. I need the distribution values for the unique figures in my Average Days column. 

 

In below example you have the unique student scores and the distribution for each one - I need to do that with Average Days through DAX.

 

 

 

I was trying to use DAX to add TFF +  Forumlas Added [Average Days] as another column in the table but wasn't able to. 

 

Any suggestions?

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

It is not clear to me what your expected outcome is. I can not help you without usable sample data. Screenshot are not usable.

  • Gezz's avatar
    Gezz
    Regular Visitor
    4 years ago

    Hi Ibendlin,

     

    I have a column called Averages Days with a series of unique values, e.g 11, 15, 42, 47, 56, 112 etc. I want to plot those with their distribution - so for each value it would be - norm.dist (11, 52.95, 19.62, false) . I would then get a value 0.0011 etc. I could then use the distribution values and the average days value in a histogram to get a skewed bell curve.

    I need one column with all the distribution values and one with all the values from Average Days.

     

    I made a table and need a column that refers to the values listed in the Average Days column which is a separate spreadsheet and then I can do a norm.dist on it I think.