cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamie_Hutch
New Member

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 columns cannot be converted to a scalar value.

 

I am using this formula below, sample data is just a small sample
 
TEST = ADDCOLUMNS('Sample Data', "Normal Distr", NORM.DIST([Value],'Sample Data'[Mean], 'Sample Data'[StandardDev], TRUE))
 
Any help would be really appreciated 
 
Thanks
2 REPLIES 2
lbendlin
Super User
Super User

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.

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors