Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Norm.Dist

Hello   I am really struggling, I cannot configure the Norm.Dist to work - I think it is to do with the X value as I keep getting the error    The expression refers to multiple columns. Multiple ...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

TEST returns a table. What are you doing with that ?

 

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello

     

    I am trying to build a table to visualise a normal distributon curve so I can calculate % probablity . I have a smaple of 30 data points in a table & column called Chol[Chol] and created measures for the average

    MEAN2 = CALCULATE(AVERAGE(CHOL[CHOL]),ALLSELECTED())
    and Std dev
    STDDEV2 = CALCULATE(STDEVX.S(CHOL, CHOL[CHOL]),ALLSELECTED())
    I then created two measures at 3 standard deviations from the mean 
    -3Sigma = [MEAN2] - (3 * [STDDEV2])
    +3Sigma = [MEAN2] + (3 * [STDDEV2])
     
    I then produced a new table with the range of data points  
    NORMAL_DIS2 =
    VAR MinValue = FLOOR([-3Sigma], 1)
    VAR MaxValue = CEILING([+3Sigma],1)
    RETURN
     
    What I then want to do is generate the normal distribution for each of these points so I can graph the curve, but everything I try doesnt work - please help or suggest an alternate method thanks