Forum Discussion
Helper IIAn argument of function 'NORM.DIST' has the wrong data type or the result is too large or too small
I am trying to create a bell curve; at the moment I am keep getting error message
I am trying to create a calculated column the DAX formula I am using is
NORM.DIST( 'RESP POP Varation'[Online POP], 'RESP POP Varation'[Average], 'RESP POP Varation'[Standard Deviation], FALSE() ) |
The Error message is
“An argument of function 'NORM.DIST' has the wrong data type or the result is too large or too small. If the argument is expected to be a date, that date must be between March 1, 1900 and December 31, 9999.”
My desired output graph is:
Please find links to PBIX file and Excel sheet file
Hmm, will have to look a little deeper. If you do this:
Table = GENERATESERIES(0,100,1)And then this:Column = NORM.DIST('Table'[Value],AVERAGEX(ALL('Table'[Value]),[Value]),STDEVX.P(ALL('Table'[Value]),[Value]),FALSE())And you plot [Column] against x, you get this:2019 - Sorry, just getting back to this now. The last file you sent was very helpful. I am sorry but I am only able to achieve the following result in Power BI.
They key is to use the Average aggregation versus the default Sum aggregation because there are multiple y values for the same x value. Couldn't get the markers, you only get those with Categorical x-axis. Attaching PBIX.
10 Replies
- Greg_Deckler
Community Champion
Your standard deviation is coming back as nan in row context, try:
Standard Deviation = STDEVX.S(ALL('RESP POP Varation'),[Online POP])Also, just curious, when did you joint the community? 🙂- Greg_DecklerBTW 2019 , the way I found this was that I removed the normal distribution column and created a column:
Column = [Online POP] & "A:" & 'RESP POP Varation'[Average] & "SD" & 'RESP POP Varation'[Standard Deviation]
Just FYI for future troubleshooting.
2019I did followed your steps but still i have not got the desired graph
this is what i have at the moment
- 2019
I have joined back in august 2019 🙂